smiley1978
Board Regular
- Joined
- Sep 13, 2005
- Messages
- 133
I have a table that is updated by an Excel Macro. The data is stored vertically. When the macro runs, one of the fields is given a date and time. This date and time is generated by the system clock and is stored in a variable in Excel. Every record that is updated by the macro is given the same date and time for each run. When I update this table, I have a field for State and one for Channel. I need to return the Max Date (the most recent run) for each combination of State and Channel. When I use the Totals option in the query, it returns everything. Can anyone help?