Question about Wizard

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I tried using this wizard, but it would not give me the
data that I was looking for. Because I wanted to search
for matching Serial/Model Numbers within a certain period
(the way the Wizard set up the query, when I put it
beginning and end dates for a time period, it gave me
records that were duplicates of records in other time
periods also). Is there any way to set it up so that, it
outputs duplicate records from a certain time period. For
example, if a record "A" is in the time frame that I
specify, and record "B" is a duplicate of "A", but is not
in the time frame, then I do not want it to output
record "A". (THANK YOU SO MUCH FOR THE HELP)
 
Post your SQL statement.

As a guess you need to modify the SQL Subquery that is in the criteria, by
adding a Where clause to it to limit matches to your date range.

SOMETHING LIKE the following- NOTE this is

Field: SerialID
Table: YourTable
Criteria: IN (SELECT Tmp.SerialID
FROM YourTable As Tmp
WHERE tmp.DateField Between #1/1/2000# and #1/1/2001#
HAVING Count(*) > 1)
 
Back
Top