|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 30th, 2006, 06:02 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Query similar data
Hi, I have a list of numbers in an access table that have a leading zero.
The table I am trying to query with has the same list but does not always have this leading zero. Is there a way to do a similar type query? The numbers are 10 digits. Thanks in advance, I'm very new to this. 
|
|
#2
January 30th, 2006, 07:02 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Query similar data
If they have leading zeroes they must be text so if you want to compare the
two sets compare Val(your number) Mathematicallly Val("00001")=Val("1")=1 xgirl wrote: Hi, I have a list of numbers in an access table that have a leading zero. The table I am trying to query with has the same list but does not always have this leading zero. Is there a way to do a similar type query? The numbers are 10 digits. Thanks in advance, I'm very new to this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200601/1
|
|
#3
January 30th, 2006, 10:42 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Query similar data
Another way:
Where Right("0000000000" & [table1].[field1],10) = Right ("0000000000" & [table2].[field2],10) Chris Nebinger
|
|
#4
January 31st, 2006, 01:07 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Query similar data
thanks, that woks.
"Bob M via AccessMonster.com" wrote: If they have leading zeroes they must be text so if you want to compare the two sets compare Val(your number) Mathematicallly Val("00001")=Val("1")=1 xgirl wrote: Hi, I have a list of numbers in an access table that have a leading zero. The table I am trying to query with has the same list but does not always have this leading zero. Is there a way to do a similar type query? The numbers are 10 digits. Thanks in advance, I'm very new to this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200601/1
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| AHHHH-Get Data from Multiple Excel workbooks | JAA149 | General Discussion | 5 | October 30th, 2005 05:19 PM |
| PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
| Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
| SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
| Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Linear Mode
