how to use one date from aggregate query

[Robo0502]

Hi guys,

wonder if you could help me. Probably easy task.

I have a aggregate qry which gives me one certain date from a source table with dates.

Then I have a table with orders which contains order date. I think there is no way I can connect order table and aggregate qry.

In a query from order table I need to compare those two dates. How to implement one date from aggregate qry to order table?

Ilustration:

qryROL:
ROL date
31.8.2016

tblOrders:
orderno/ orderdate
2334/ 14.5.2015
2434/ 2.2.2015

any idea?

Thank you

 

[Frothingslosh]

One way would be to compare against a DLookup of ROL date. It can be run against queries as well as tables.

DLookup is really slow when used to search a table or query with a ton of entries, but if your aggregate query only has one record, you shouldn't notice any slowdown.

Another way would be to build a query basing data on both your table and the aggregate query, assuming you can relate the two somehow through some mutual key. Then you can treat them like any other fields, save that the resulting query will NOT be updatable.