The way to check is to query the DB for that new user name and that email address before you write the new ones to the DB
If you get a EOF the new ones were not a dupe
If you get a hit the new ones are dupes
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
Re: Identifying Duplicate Records ...response to what appeared to be a barely relevant question. ... in the list of options is Find Duplicates query.... or bring up the dupe records to look at them. ... have a find duplicate records wizard.... (microsoft.public.access.formscoding)
Re: Identifying Duplicate Records ... Whatever you use, you then can use the results to flag the dupes for review in one way or another, or bring up the dupe records to look at them. ... This is a tricky little query to understand, from a beginner to intermediate point of view. ... To find our duplicate records we build a query inside the IN function that will return only those values that occur more than once in the table. ... then comparing the results but the details of ... (microsoft.public.access.formscoding)
Re: Mileage Query (Newbie) TIA ... I like your use of "Dupe" as the table name alias. ... MS Access MVP... > Try typing this into a fresh column of the Field row in your query:>... >> What I need to be able to do in my query is to have the date go back to> the last day that mileage was entered and subtract the previous days mileage> from the next date to give actual milage driven on that> particular day. ... (microsoft.public.access.queries)
Re: Compile Error - SQL View ... and pasted your SQL.... There is no need for any table called 'Dupe' to exist in this scenario, ... used in your query to refer to a second instance of the 'dupelist' table. ... > FROM dupelist INNER JOIN dupelist AS Dupe ... (microsoft.public.access.queries)
Re: More questions for Tom Ellison ... You have the FROM clause twice in your main query. ... (SELECT TOP 1 Dupe.[mL Gas] ... FROM qry__O2_CO2Trap AS Dupe... The subquery will give you only one value as the PriorValue, for every record in the main query. ... (microsoft.public.access.queries)
