Can anyone tell me how to query a option group.
I have an option group with 3 choices.  Yes (1) No (2) Missing (3).  The
values are in brackets. The field is a number data type.  What I want to be
able to do is make a query that will tell me that how many Yes's, No's and

I'm still a bit new to building expressions in Access.  I've been working in
a query, on sales data.  
The sales date table has "Date", "Quantity", "Taxable Items Price",
"NonTaxable Items Price".

We just moved the Access database back-end to SQL.  All queries are in the
Access front-end. Should I move the queries used for Mail Merge to SQL, or
keep them in the Access front end?

I have 2 percent and I need to calculate the average of the sum of them in
Query
Can any body help me please?
Thanks!!

I'm developing an access application using XP version.
I have a listbox on a form with a row source of a query that calculates
dates using dateadd function.
This query wont return results for some computers and for others it's ok.

hi community
any help much appreciated in this query...
scenario
had 3 tables created but they are not link to each other

Hello all. in my table I have a lookup, which looks up a Boat Number.  When I
created a query on that table, the results only show me the autonumber for
that boat, not the boat number. As a matter of fact when I go into datasheet
view of the table it shows me the same.

I'm a bit of a novice at Access, but have created a form and subform to allow
quick entry of Purchase Order details for our company.  The purchase order is
for us to track who our suppliers are and to issue purchase order numbers for
suppliers.  I have used unbound text boxes for ...

I am trying to provide the user with an option to define some queries where
I am pulling a given number of characters using a build in fuction (left) but
I am getting the following error and I am not sure why.  I will really
appreciate your help.

I am new to Access and having a difficult time.  I have built some tables and
would like to create queries and reports.  One of my tables has a key field
which, for the sake of simplicity, think of as a unique person_id.  Two of
the fields related to this key field, think of as ...

Hey people.
Am getting that very annoying "query is too complex" error come up on my
database.
Unfortunately I cannot post all the SQL just yet as I am at home and my

Hello - I have 1 table with many fields, 3 of which are [VIN], [ORDER #], and
[SHIP TO].  There is currently data in [ORDER #] and [SHIP TO] but not in
[VIN].  I have downloaded an Excel spreadsheet with updated data and have
used it to create a new table with the 3 same field ...

I have a database of over 380k records that I need to separate out by zip
codes.  What I am doing is getting a 50 mile radius of my directors across
the country and this program comes up with a list of zip codes in that
radius.  Just for OR, I have 7 pages of zip codes (182 zips) ...

As I am new to access could someone explain please in "Layman" terms. I have
set the formula Format([Date],"ww") to display the week number representing
the date I entered. Problem is if the date I entered is a Sunday date it
shows the next week number when my business ends on a ...

I have created a search form using the following query to fill the subform.
It works as long as I type in the exact data in the column.  I would like to
use the Like operator but when I do I get no results.
This is the original query: