query parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
Back
Top