query parameter

V

VAL

I have fields in which there are numbers, i.e. Field called A, content: 1234.
I need to know how to query as follows:

list all fields that don't contain any of the individual digits found in
field A... (i.e. 1 - 2 - 3 - 4). So it should return fields like 6789, 9867,
7598, etc.

THANK YOU
 
J

John Spencer

Are the fields number fields or string fields?
Are you searching other fields based on A?

You basically need to split A into its component parts and then do a search
on each of the components. You probably need a custom function to do this.

Are you comfortable with VBA code?
 
V

VAL

I haven't set it up yet so the fields can be whatever you recommend. Because
I have to query on field A, then field A and B, then field A and B and C,
ETC, it cannot start saying in the query (and don't know how to do that
anyway) to not include number 1 and not include number 2 and not include
number 3, etc. It would take for ever.

And the extent that I am familiar with VBA code is to copy them from another
database or user, insert it into an event... and modify parts of it sometimes
IF it is VERY simple... I have never had to really create one on my own but
I am very resourful. I have created a large database for a school which
responds quite efficiently to all their finance and administrative needs
solely based on bits and pieces of databases I copied from and help here and
there. So I may not understand the actual coding but I am used to
deciphering and testing what they do...

Please don't give up on me, and help! I need this urgently for my son's
soccer team!

Val
 
Top