I have a field called position code (PC), this can have many different
values. What I need to pull all PC's that are 1010, if not then 1005. but not
both. How do I go about doing this?? The 'OR' Function pulls both.

I am trying to write an expression (formula) for a Select Query to extract
the first group of string.  I have tried the functions "MID", "LEFT",
"RIGHT", etc, and they don't seem to work.  Below is a sample of data:
AA American Airline

I have field with Participants ages. I need to get the correct LE_VALUE for
that participant. I have 3 fields in one table in my query which are all
Number datatypes.
I need to subtract 10 from the age in turn will give me the correct data in

When opening my Query, (which used to display information correctly) I now
get "Specified field could refer to more than one table in the FROM clause of
your SQL statement.  The Query then opens in the SQL View.  I'm trying to
view the Query in Design View and it will not allow ...

I need to convert a number field to a text field in a query, and I have used
format(quoteID, "00000000")
This isn't working for me for a couple reasons;   1st reason is that by
changing the number to have padded zero's this table won't coorelate to the

I want to create a query to show me all records with a Payment type = "event"
while excluding records with a Payment type of "Donation".

I have a table with a Birthdate field with date/time datatype. I need to have
a field in my query that will accept the actual age of the Participant.
Example..Birthdate field has participants birthmonth such as 11/12/1929. I
need a field in my query to show the actual ago of this ...

What I need to be able to do is to calculate the difference in a value
(Temperature) between each depth bin.  Then to find the absolute value of the
biggest difference by Station Code and then to find out the Depth - 1 at
which that biggest difference occurred.  I am sure this ...

Is there any way I can select recors randomly in  query?
What should I do for that?
Any help, really appreciate.
Thank you

I have a query with two tables and two fields that make up this calculation
The Birthdate field is a Date/Time datatype and the Age of Customer is a
Number datatype and will hold the calculation.
Example..

rIs there any way I can select 10 records randomly in query?
What should I do for that?
Any help, really appreciate.
Thank you

Please help!
    I have a Report that is getting it's Data from a Select Query. The
Query has five Columns named, Pass/Repair/Reject 1, Pass/Repair/Reject 2,
Pass/Repair/Reject 3, Pass/Repair/Reject 4, Pass/Repair/Reject 5 and five

Ok... I'm trying to filter data in a report, but still have access to some
other pertinent fields.  I want to have a query in a report that refers
mainly to the table "data" so that I can have access to all of the fields in
that table, but I would like to filter the records based ...

I am trying to insert a table (tabtest) based on the value(accountno)
from the query (qryemployee).
This is the query I have,
strInputFileName = EmployeeName

I have created about 10 queries from the same table (they are just numerical
totals). But now I would like to display the results of each query in one
report. How do I do this?