I deal with a database that feeds off of records sent to us; with one particular query, I am trying to track last visits from retailers, however the query I have set up does not agree with the records and I am lost as to how I can update this query...please help!!!

Update the table it's based on?

Rich, is there anything special I need to do to update the table that I'm using?

Does the query have any selection criteria that would cause it to return fewer records than just opening the table?

Hi Pat...I'm drawing off of a table that tracks these records; I've included a field in part of the query, in the "total" row I have the word "last", and as criteria I have the expression "<1/1/02". By this I hope you understand my situation; is there any suggestions that you can give me at this point?

Thanks
Joe

Change last to Max on the date field