Display earliest date from query on form

[jt196]

Hopefully this is just a simple one.

I have a bunch of records (orders) with dates on them that show up in a query. I'd like to display the earliest date on a form - ie the date the longest amount of time ago.

I imagine that this is some sort of text box with some type of sorting, but I've no idea what to put in there.

Any help would be much appreciated!

James

 

[Trevor G]

Select your query in design view, then go to the date field, then in the sort option select Descending

 

[jt196]

Thanks for your reply, Trevor - I need to display this on a form. How exactly do I go about doing this then?

I put a text box with the line: "=[Q_OrdersFinSumNoInvoice]![Due Date]" where the first bit is the query and due date is the date I want - but I just get an error message.

Sorry - a bit of a newbie so apologies if this is obvious stuff.

 

[spikepl]

look up Dmax in the documentation

 

[Trevor G]

Thanks for your reply, Trevor - I need to display this on a form. How exactly do I go about doing this then?

I put a text box with the line: "=[Q_OrdersFinSumNoInvoice]![Due Date]" where the first bit is the query and due date is the date I want - but I just get an error message.

Sorry - a bit of a newbie so apologies if this is obvious stuff.

If the form is made up from the query then what i have said will work.

If you want additional options for sorting on a form you can add some code to sort via a field.

 

[SeanD]

Hopefully this is just a simple one.

I have a bunch of records (orders) with dates on them that show up in a query. I'd like to display the earliest date on a form - ie the date the longest amount of time ago.

I imagine that this is some sort of text box with some type of sorting, but I've no idea what to put in there.

Any help would be much appreciated!

James

add ORDER BY DATE to the query ??

 

[jt196]

Thanks very much for all your help!

I put in

=DMin("[Due Date]", "Q_OrdersFinSumNoInvoice", )

To text box and it worked.