sub form

[sadie]

I have a database where I track the employees salary history.
The salary history is in a subform of my main form with other employee info

Is there a way to query this sub form so I get just the latest salary increase

 

[charityg]

Try something like
Select Max(DateofRaiseField) as RaiseDate, RaiseAmount from
Your Table
Group BY RaiseAmount

 

[sadie]

thanks, but where do I enter this
the info is in a sub form