identifying new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i run a qry on a bi monthly basis and i continually update the date
parameters and want i want to do is to show some how what are the new records
by adding a (month abbrev like feb) after the customer or # of cases

I have customer name, id, # of cases and product descriptions

any ideas???
 
The simple way: Create a new Date/Time field in the table. Make the Default
value of the field Date(). Don't even mention this field in an update or
append query or form. Then you can do which will show the latest dates for
records based on that field.
 
If the database is small enough and has nothing too sensitive, zip it up and
send it to:

(e-mail address removed)
 
Back
Top