Hey guys, this probably has a simple solution but I have no idea how to fix it
What I want to do is have a macro run a query (which I have no issue on doing) but then have the query display the result from the latest record.
-If that made no sense:
I have a query which has multiple fields (all of which fill) and one of those fields is ServerID.
So instead of having to add [insert ServerID] (or something) I would like it to do something like the Date() function, but for the most recent ServerID and all related fields.
If you need anything clarifying just ask
Thanks for your help
-Jordan
What I want to do is have a macro run a query (which I have no issue on doing) but then have the query display the result from the latest record.
-If that made no sense:
I have a query which has multiple fields (all of which fill) and one of those fields is ServerID.
So instead of having to add [insert ServerID] (or something) I would like it to do something like the Date() function, but for the most recent ServerID and all related fields.
If you need anything clarifying just ask
Thanks for your help
-Jordan