How do I query the most current date in an access database so it .

[C Markowitz]

I need to load the most current sales information on a form. I am really
struggling with how to load the current sales data in real time. Let me
explain my design a bit - I have two linked forms to toggle between basic
information about sales people and their current sales so I already have code
in the Current property for the form.

I am trying to create a summary type of form where it displays the most
current date and sales figure.

Any suggestions? I would appreciate any help anyone can offer.

Thank you.

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 approaches.

 

[C Markowitz]

Thank you - just what I needed.

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 approaches.