Recent content by IllinoisREI

My list of queries is growing out of control. I frequently find myself creating multiple select queries to be used to create other select queries because of the need for unique joins at each stage. I've combined queries with union queries using straight sql but is there a similar approach where...

PHV: Thanks again for the reply. I gave it a try but I'm getting a "Synatx error (missing operator in query expression)". Would the domain being a query versus a table cause a problem with the Dmin function? What is the reasoning for Field1 in square brackets and not Field2? Also, what does the...

Thanks for the feedback guys. I wasn't clear in my post. Field3 needs to be the result of an expression. It does not exist yet as a field in any table or query. The expression would result in a date. I need it to look at the value of field1 in that record, then look through all the records and...

This has me completely stumped. Using this table as an example, ID Date Field1 Field2 Field3 1 1/1/09 600 0 1/4/09 2 1/4/09 600 600 1/4/09 3 2/1/09 1200 600 2/15/09 4 2/15/09 1200 1200 2/15/09 5 3/1/09 1800 1200 4/1/09 6 3/8/09 1800 1200 4/1/09 7 4/1/09 2400 1900 null 8 4/6/09...