run query or report on new information

[odun]

Hello all:

Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table.

How do I print a query or report right after the download, that will provide a list of the new information just downloaded.

Thanks for all your help!

 

[Pat Hartman]

The simplest solution is to add a new column to the table. Use the date datatype and set the default value to Date(). To find the records that were added on a particular day, create a query that selects records using criteria that prompts for a date.

Select * from your table where AddDate = [enter date];

 

[odun]

Thanks Pat, I have included the default date thing.

Thanks.

The simplest solution is to add a new column to the table. Use the date datatype and set the default value to Date(). To find the records that were added on a particular day, create a query that selects records using criteria that prompts for a date.

Select * from your table where AddDate = [enter date];