I am trying to transpose multiple columns into a specified column as shown
below.
What it looks like:
1(Q1_A_1)  1(Q1_1-2)  1(Q1_A_3)  1(Q1_B_1)  1(Q1_B_2)  1(Q1_B_3)

I have created a query based on one table to search for dates in a certain
range, for example May, by searching the date field with the criteria Between
[enter start date] And [enter end date]
It pulls up most records but always leaves excludes a few records which

I have a years worth of data where I'm trying to find records with duplicate
values in the "IndividualName" field.  I am using the find duplicates query
in Access 2000.  However, I only want records to return as duplicates if the
the "DateCreated" field are within 30 calendar ...

I am having a very difficult time with a query.. It work before and I have
taken out any changes that I made and now it does not work.  HELP please
This is the basic select query that selects data.
SELECT F4F_SubStudioDetails.Date, F4F_SubStudioDetails.Studio,

I'm looking for a way to find the field from one table within the
field of another table. For example:
Table1 => Field1 = Group1
Table2 => Field1 = Group1, Group2, ... , Groupn

Name       employer 1      employer 2     employer 3    employer 4    emloyer 5
I have a sheet in access with these headings ...
1 Can I construct a parameter box that pops up and allows me to querie up to
five names at a time

I need to convert using a query the date format from MM/DD/YYYY to YYYYMMDD.
How do I do this?
Thanks
Matt

I'd like to create a view that returns numbers 1 through 364.  Ex:
NUMBER
1
2

I have a table like this:
DATE           |      NAME
01/01/2008          Name 1
01/03/2008          Name 2

I am trying to update a field but get an error message that some of the
records were not updated due to key violations. However, some records are
updated. The field that I want to update is a text field that is not the
primary key. Any ideas?

I have a database that tracks estimator usage by dispatcher.  It also tracks
the date the info was entered.
I want to have a report that shows % of each estimator (there are 4 types)
used for each dispatcher.

Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used?  I have a table called tblCustomerRollup which is
old and outdated.  I want to see which of the 500 queries in my database use
this table without opeing every single one of ...

I am struggling with a query, and need help
I have (from a previous saved query) these fields:
Field1, Field2, Field3, Time, Info
What I want to return is the maximum and minimum time along with the

I need help - I have a crosstab query showing activity by territory,
with totals and averages that looks like this:
              Terr1     Terr2    Terr3    Terr4   Terr5    Total
Avg

I am trying to create a new database using existing information. I currently
have a table called "TBL_Members". This has SS#, name, address one, address
two, city, state, zip code.
There are times when correspondece needs to be sent to the member, and other