Rolling query

T

THE BIG O

I would like to create a Find Duplicate query that collects information from
a table using a rolling year. Essentially we are going to import shipments
into a table on a daily basis.

This table is already at 147000 shipments. I need to make sure that no
shipment two shipments have the same Pro #. Should I just query a table with
the last two years of data or attempt to do the rolling year?

How do I do the rolling year in a query?

thanks

michael
 
T

THE BIG O

SHINY,

thanks for your help guys. I wish I had more time to play around in access
and try to learn these on my own but receiving an average of 10 project
request a day keeps my group extremely busy.

thanks

Michael
 
Top