Greetings, I am having trouble wording the subject of question.  In a
nutshell I am running a macro that exports a query to an excel file.  The
query as currently done exports many fields including the field [amount]
which I would like to split based on a criteria [preferred].

I run a query on a 'tblCandidates' table linked to two other tables
'tblCandidateIndustries' and 'tblCandidatePositions' each of which may have
many records pertaining to the Candidate in the parent table.
The query returns every permutation of Candidate, Industry and Position in ...

Hi, please help if you can.  
i need to filter data and have built a query but i cant get it to work.  
there are 10 columns in the query each contains a date, or is null, which
represents when some one qualified for something.  

I have a function that returns a string that I would like to use as the
criteria in a field in the QBE query grid.  I know the return value for the
function is correct, however the query seems to be treating the whole thing
as a string.  For instance,  if i pass "H, U" to the ...

I need your help to refine what I'm looking for.
I have a table with the following fields: SKU,PURCHASE_ORDER,QUANTITY
Example:
SKU       PURCHASE_ORDER   QTY

I thought that if I put six different expressions in a query, that Access
would go through the table data six times and essentially run six different
queries.  But in the expressions below there is an overlap between Class1 and
Class5 because Question #30 [QNUM]=30 could also ...

I am trying to alter the following query:
SELECT dbo_Requests.Req_Date, dbo_Requests.Version, dbo_Requests.File_Name,
dbo_Requests.Company_Name, dbo_Requests.Contact_Name, dbo_Requests.Country,
dbo_Requests.Phone, dbo_Requests.Email_Address

Writing a QBF but having problem searching a time field.  It was created as a
text field, so I wrote my criteria as a text field, see below.
   If Not IsNull(txtTimeserved) Then
   If Whereclause <> "" Then Whereclause = Whereclause & " AND "

Hi guys, I've had this problem before and never fully resolved it so am
trying again, this time with a different tact.
I have a form containing 6 combo boxes. A sub form in the bottom of the form
changes depending on which combo boxes have parameters set. For the most part

I need to add a calculated field to a table containing tens of thousands of
records in Access. This field will contain the time lapsed by Trip and by
Date as sampled below. Eventually, I will need to select the records with a
given Time_Lapsed.

I am teaching myself Access and SQL as I need it on the job, and I want to
thank everyone who has contributed to this discussion group for all of your
very useful guidance.  So far I haven't been able to find an answer to a
problem I'm having with an Access 2000 query and report ...

What is the best way to filter through multiple fields to get an answer for
another field?
i.e. I have 10 seperate fields I want to filter through.  Each field will
have text or not.  If it does have text, I want to put a comment in a new

How can you compress / group by on a crosstab query when the amount of
column names are unknown ?
If I run a crosstab query for example I may have 1, 2, 3 or 4 quarters
listed as column names.

I am new to databases. At the moment I'm trying to make a film database. I
want the query to search for a given films actors.
However I would like the parameter value to then say 'sorry this film does
not exist' if the user enters a film that is not there!

Hello,  I have a Query based on 2 tables and another query.  All three are
joined by the field ID (PK in the tblComplete List of Contacts table).
I want to select certain records from the Affiliations table (those where
the yes/no Business field is Yes) and certain records from ...