>Dear all,
> I am having difficulties trying to find a way to sort some details. I am currently working on a personnel project and I sorted and listed all the personnel's rank as the parent report and I link it to the personnel profiles so all employees under that rank will be listed. however, is there a way to sort the listed employee by bday?
>I have tried creating the bday as the accending key, but dont seem like to work in the report form.
>Thanks
>Tom

something like this...

select * from personnel, profile
where personnel.key = profile.key
group by personnel.rank
order by profile.bday