Hi, I am very new to Access and am having some trouble.
I have two tables in my DB, one called Data that contains approx 14,000
names and another table called Returned that has approx 1000 names. I want to
create a query to remove the Returned names from the list of names in the

I have a table, laid out as follows:
Acct, Year, period1, period2, period3, period4,...through period13
Sales 2006  $1000     $2500    $3100    $1250   
What is the easiest way to return each record as 12 records,

I must have a metal block today. I need a Like Operator that will find
fields with just letters of the alphabet and a lenght of 6 or less.
The best I can come up with is:
field Like "[a-z]" OR field Like "[a-z][a-z]" OR field Like

I'm trying to get a number like 41.8125 to round to the nearest 1/8 ( 41.7/8
or 41.875 )
Please help.
Thank you.

Hello, I need help with this problem. I have two lists of dates. I am
using a table as a filter for this list. What I want to do is create a
final listing of all dates that are less than the minimum date in the
filter. This is probably easier to demonstrate than to explain:

I have been using my database for over 1 year and have been pulling a query
which uses a beginning date and ending date to pull my information.
I have had no trouble until May 4th.  I had entered my information and went
on to 5-5-07 and then had to enter more information for May ...

currently i have a table in MS Access which has many fields A B C D E
F G for example.
I would like to get a summary of the number of "filled" columns in
each of these cols.

I have a simple table with the following fields:
ModelType    text
ModelID        number
SaleMonth    date (mmm-yy)

I have built a crosstab query showing counts by crew numbers for a basis of
a graph that will be shown by only 'Inside' and 'Outside'.  I would like to
group together in the crosstab all the 'outside' crews i.e. Crew 1,2,3 and
show them all together in the crosstab as 'Outside'; ...

I thought I knew how to do this, but for some reason it's not working - I
could use some help.
I have two tables:
MSTR_TEST - a master list of available tests, key is testID (testID,

I am converting an Oracle database to Access.  When recreating my queries I
cannot figure out the syntax for the LIKE expression.  
Oracle:
SELECT ORDNUM, CUST_LNAME, SALE_DATE

I have a very simple table with my distributors in it ( firstname, lastname,
address, city, state, zip and 2 checkboxes) what I would like to be able to
do is have a "query" textbox on one of my forms so that i can type in a field
to search for such as locating all distributors ...

I am converting an Oracle database to Access.  When recreating my queries I
cannot figure out the syntax for the LIKE expression.  
Oracle:
SELECT ORDNUM, CUST_LNAME, SALE_DATE

Is there a way to write a query where the column heading will change like a
variable.
I would like to write a query on products where the query would request
information on a particular product ID, but the display of the information

How can I set the query so that it will only show the values whose check
boxes have been checked? What should be the criteria? Any help would be
greatly appreciated! Thanks in advance!