G
Guest
I've tried to create a query that identifies the last record entered into a
table. The field I'm using with this totals query is called projectID which
is defined with an autonumber format. Each time I run the query it returns
the record with ProjectID=93 but there are 108 records in the table, so
shouldn't the query return a value of ProjectID=108? I can't figure out why
this is happening. Does anyone have any suggestions?
table. The field I'm using with this totals query is called projectID which
is defined with an autonumber format. Each time I run the query it returns
the record with ProjectID=93 but there are 108 records in the table, so
shouldn't the query return a value of ProjectID=108? I can't figure out why
this is happening. Does anyone have any suggestions?