I need some help!
I have made a form where the user should be able to extract data between
entered years, which can be chosen from two comboboxes giving the from and to
year  parameter!

I am new to Access so bare with me.
I have a table with duplicate records. I need to count the distinct values.
I understand 'distinct' will not work in Access. How else can I count my
records without duplication?

I am trying to automate fiscal period in a query. I want the criteria to look
up the current system date [date()] and classify that date into a fiscal
period (which I have a table (calendar) to show which dates go into which
fiscal period. Our calendar is based on 4-4-5 week.)

Is it possible to insert an expression that creates a column to produce the
same information for each row?
cheers in advance.

I have set up a form for a Bus timetable which has a selection for Day and
Locations which uses a Check Box method, i.e if you want a trip on a monday
select yes and which time points did you want listed. The trouble i am having
is the fields that are not selected are still ...

First please be patient-- I'm somewhat new to Access, and am having trouble
with a query.  I have two tables (1. Certifications (Field- Certifications);
2. Skills (Field-Skills)).  I currently have a form which allows the user to
look up certifications by pulling the list of ...

i HAVE 2 DB WITH THE SAME FIELDS, NO AUTONUMBERS, I HAVE TO MAKE A REPORT
EACH MONTH ON ITEMS RECIEVED FROM BOTH THESE DB, INTO 1 REPORT NOT 2 SEPERATE
ONES. CAN YOU HELP ME ?

Hello everyone, I am a first time submitter.  I have a technical question for
you, which is as follows:
I have two queries that I need to connect in a new query.  The first query
is called qry_RISK, and the other is called qry_CONTROL.  The best primary

I have a parameter query that gets user input, and then displays the query
result in a Form. The Query selects and combines data from multiple tables
onto the Form. This is a read only form, since it is not displaying the
actual fields from the data base.

I use a Access Time Clock to tract employes hours. An employee enters his
EmId and clicks a command button to SignIn. The computer enters the date &
time. He does the same to SingOut. Sometimes someone forgets to SignOut. How
do I restrict the next SignIn before correcting the ...

I have a table post dates that span many years and an amount column.  I need
a cross tab that handles the amount in a running sum format.  For example,
the first payment was 1/1/06 and the amount was 100, on 2/1/06 the amount
posted is 100, but I want the amount for that column ...

I have the following Update query, which works fine.  However, if there is no
longer an inner join record in the ExcelARefParts table, how can I update the
fields in the AllNewParts table to null?  Thanks.
UPDATE AllNewParts INNER JOIN ExcelARefParts1 ON (AllNewParts.[Model#] =

Any way to use a GROUP BY function, or some other function, and then to
concatenate the returned string values in a particular field, from each
grouping?

Hi, I actually asked this question already, but I cannot find the
answer or the question for the life of me so I am going to ask it
again. I need to find the Number of customers that a company has based
on the invoices. I can't just Count normally because it will count a

Have made a qrosstab query that works fine. Have also been able to use the
wizard to generate a report from it. Then I got a problem when I tried to
let the query read the WHERE conditions from a form. I need to get only the
records from a certain customer on a special day. So I ...