I have a huge table that contains three columns with data but only one
column per row can contain the search criteria, example column A=Phone1,
B=Phone2 and C=Phone3. The search criteria is "Home Phone". I am trying to
search all three columns for the search criteria and biuld ...

I am trying to create a query in Access 2003 that will give me a list of ID
numbers that are repeated (X) number of times. For example I want a list that
will give me all id numbers that are in my table 8 times. I am thinking I
need to use the "count" function, but everything I ...

how do you write a query to do a sort of VENN [diagram] UNION or Interesection
between two tables?    In the 4GL FOCUS Language, you would query table 1
and place the output on HOLD sorted by key 1. Then query Table 2 and place
the output on HOLD sorted by key 1.  Then you would ...

another wierd query question. i have a union query where i get some
duplicated part numbers. there is a field that i would like to show the
actual data for, but i would like to show the quantities as a sum. let say i
have 2 lines where the part number is 321123 and a qty of 5 and ...

I'm having a problem with subreports based on parameter query, however, I
don't understand about the master child fields.
My report is set up with one subreport (that will only return one value) in
the page footer section, another 2 subreports (returning multiple values) are