I need a way to choose records based on the last monthID and the associated FormulaID. Maybe like a 2 field MAX problem ??
Attached is a small file to try. I need to records to show up in the query 8510Qry-P05 Total Fixed Cost
The 2 records would be for:
692030 for month 200908
692744 for month 200909
The rest do not need to be seen. I even tried making an extra query level but it did not return my 2 records.
What do I need to do? I am looking for a formula's last month number.
Thanks, Molly
Attached is a small file to try. I need to records to show up in the query 8510Qry-P05 Total Fixed Cost
The 2 records would be for:
692030 for month 200908
692744 for month 200909
The rest do not need to be seen. I even tried making an extra query level but it did not return my 2 records.
What do I need to do? I am looking for a formula's last month number.
Thanks, Molly