I have two tables--DOCMASTER and DOCOFFICES--linked by a DocId field.  This
is a one to many relationship, one doc can have many offices.  I need to
create an extract of this information to supply an outside vendor.  The
problem, as I see it, is creating the format of the file ...

I unfortunately need to score a questionnaire and I can't get around the
calculations needed to get the final data score...any suggestions?

In one of my tables, I have a date field formatted as MM/DD/YYYY.  I would
like to grab the month only to use in another field, but because the date
shows as 8/30/2005 or 10/1/2005, I can't use the "left" command because
sometimes the month is one character and sometimes it's two ...

I created a query from my employee table.  One of my fields is named Title.  
Within that field I have more than one type of title.
Example:  Titles are KBSI, KBSII, CLRKI, CLRKII etc.  
I want the total number of each title.  I think I am supposed to use the

I am running into a FY problem with a query I am creating to do running
totals.  I have a table with the following pertinent fields:  Regional Sales
Manager, OrderValue, and OrderDate.  
I created a query that does a running total showing that in month 1, $$$ was

I am a novice to microsoft access, and am finding some difficulties
with steps to complete a very simple database. The information
currently stored is a supplier list, with supplier
id-name-address-email-contact-notes, I want the users of this database

I have a SQL database which contains records of all students in my district.  
The fields include, school, firstname, lastname, etc. and I want to create
user accounts based on the first name. I would like to run a query that would
take the first name and transform it into a user ...

I find that when I go into MS Access Help (that is access help NOT excel) I
find listings for Worksheet Functions. One is Today(). In access it doesn't
work. It gives an undefined function. If course "=today()" works fine in
excel. Why do I see excel stuff in access. Noticed I ...

I created a table that has yes/no data fields and am unable to query.  I
receive an error each time I try.  I am looking for a list of common query
criteria.

### PROBLEM
I am looking for a more 'clever' way to put together a SQL
WHERE clause in msft access, so that I do not have to re-write
a particular SQL query whenever the fields in a table are

If an incident  occurred on a given date and the report is due 15 business
day I need a query to return the date on which the report is due

I designed a spreadsheet in Excel using the frequency function to count the
number of sales that fell between two sets of values in increments. Is there
a way to do this in Access? I would like to use Access for this in order to
be able to create additional reports. I was ...

Dear newsgroup
I am trying to make a my first access query. Here is what i want to do:
Two tables regarding delivery of containers which we empty and send back.
Delivery: Delivery Note*, ContainerNO, InvoiceNO, weightIn, DateIn

I know this must be simple, but so am I. I am trying to write a query that
will list work order numbers by date, like this:
8/1/05   8/2/05   8/3/05   8/4/05
1234       1247     1258     1269

I created a Crosstab Query for records which were split up by Months and
Locations. Locations was the Row Heading and the Months was the column
heading with the Sum of money they collected at each location for each month
as the value being calculated at the intersection. I got ...