Re: Like and extra 000's
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
RogueIT wrote:
>In tableA.upc I have a field that holds 697807070369 for a value
>in tableB.upc I have a field that holds the information but has leading zeros.
>Also not all items have the same amount of leading zeros.
>How can I query those fields to show me the information for tableB.upc?
Assuming those are all TEXT fields, this might so what you
want:
tableB.upc Like "*" & tableA.upc
but if tableA contains a code like 56789 and tableB has one
like 123456789, it will still match.
If that kind of combination could occur, then you will need
to write your own compare function.
--
Marsh
MVP [MS Access]
.
Relevant Pages
- Re: repost from scripting about sig fig functions
... > counting as significant. ... > zeros any less significant than other numbers when in that position? ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
(microsoft.public.inetserver.asp.general) - Actual Work appears twice when building Proj Center views
... while the other shows all zeros. ... When I look at my available fields in Project Pro, ... and it is reflecting the actual work values I ... Prev by Date: ...
(microsoft.public.project.pro_and_server) - Re: How to format Zip Code from 9 to 5
... [MVP - Microsoft Word] ... Doug Robbins - Word MVP, ... are only zeros in the plus 4 field, but if there ARE numbers what I get is ...
(microsoft.public.word.mailmerge.fields) - Re: Robert Widlar Stories
... Looks like it was Shockley Semiconductor Laboratory: ... >Reply in group, but if emailing add ... >2 more zeros and remove the obvious. ... Prev by Date: ...
(sci.electronics.design) - Re: Custom format leading zero
... Thank goodness someone who knows Access came along.Here is a shorter formula that will do the same thing your formula does... ... Rick (MVP - Excel) ... when you import it into Access the leading zeros will be ...
(microsoft.public.excel) |
|
