Rolling query

[Guest]

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

 

[Guest]

How do I do the rolling year in a query?
Between Date()-365 AND Date()

 

[John W. Vinson]

Between Date()-365 AND Date()

nitpick: fails on leapyears.

BETWEEN DateAdd("yyyy", -1, Date()) AND Date()

is safer.

John W. Vinson [MVP]

 

[Guest]

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