I'm trying to find duplicates within a table where a field name called APP_KEY is made up of 12 digits. However, I want the query to ONLY find
duplicates based on the first 9 digits: For example,
APP_KEY:
123456789001
123456789002
123456789003
123456789003
123456789003
I want the query to show me all FIVE records because they are all alike
within the first nine digits. I don't want just the last three!
Can anybody please help me? I've tried everything I can think of but my
access expertise is very limited.
Re: Maketable query a text field is changing to expoential number? ... If you do want decimal places, you can use the currency data type -- this will give you 15 digits before the decimal and 4 digits after ... It is not a good idea to use single or double precision numbers to link fields or for exact comparisons, because of the way they are stored ... I then have a make table query to make tables needed to view the results in reports based on product lines. ... Also for some of the items it is changing it is duplicating, but if I run a find duplicates query is shows nothing, implying there are no duplicates. ... (microsoft.public.access.queries)
Re: Duplicate Records From a Table ... >> I'm trying to find duplicates within a table where a field name called ... >> APP_KEY is made up of 12 digits.... I want the query to ONLY find ...Prev by Date: ... (microsoft.public.access.queries)
Re: Duplicate Records From a Table ... You're right on the money with what I want. ... >>> I'm trying to find duplicates within a table where a field name called ... >>> I want the query to show me all FIVE records because they are all alike ... >>> within the first nine digits.... (microsoft.public.access.queries)
Re: Select Query; if statement in one field? ... A Union query can be entered only in SQL view. ... FROM AcctRepList INNER JOIN VendorList... VendorList.acctRepCode is Null, 2, or 3 digits... (microsoft.public.access.queries)
Re: Using LIKE in a JOIN ... of digits. ..."Jason Lepack" wrote: ... be asking too much for a query.... columns from Table1) and CREATOR... (microsoft.public.access.queries)
