finding records matching an approximate value
From: Ken (Ken_at_discussions.microsoft.com)
Date: 01/04/05
- Next message: JL: "RE: Queries"
- Previous message: Sharon: "Queries"
- Next in thread: PC Data***: "Re: finding records matching an approximate value"
- Reply: PC Data***: "Re: finding records matching an approximate value"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 Jan 2005 09:41:01 -0800
I would like to search a pile of records with a field matching all the
characters from a field in a form, but it doesn't have to be exact.
for example the field on the form may be: "d86-934"
and the field in the record could be: "00d86934"
Is this possible with something like this?
SELECT records FROM records
WHERE (((records.CONT_NO) Like
[Forms]![Select_SH_NUM]![ROAD_HIST_TBL2].[Form]![CONT_NUM]));
Any help is greatly appreciated.
- Next message: JL: "RE: Queries"
- Previous message: Sharon: "Queries"
- Next in thread: PC Data***: "Re: finding records matching an approximate value"
- Reply: PC Data***: "Re: finding records matching an approximate value"
- Messages sorted by: [ date ] [ thread ]