I need to calculate sales order MTD totals and YTD totals per month in
a query. The query will show the following fields:
Part#, Order Period (YYYYMM format), MTD Orders, YTD Orders
I am getting the information from our transaction-based information

I am having difficulty counting numbers within a very large table based on
survey results.
The table is set as follows subjectname, q1a, q1b, q1c, q1d...q5e
Values for each question range from 1-5 and the field could be empty if no

I have a pipeID and DateCCTV.  A pipeID can be DateCCTV many times.  I'd like
to get the most recent Date of the DateCCTV for each pipeID.

Hi, I am using a simple basic criteria to search for a certain number
(parameter is entered) in the database.
I have a form set up that runs on this query and displays the information for
that number, which can be updated.

I created the a table with a 3 field index as part of the Primary Key.
On a daily basis run from a macro, all data from the table is deleted, then
an append query is run to insert the new data. Duplicate data is not appended
as per the key. The database is running in Access 2003.

I have a query with fields such as date, Item Number and Quantity.  I want
to create an additional field called Count that will act like an autonumber.  
It will assign a value of 1 for the first record, 2 for the second number
etc.  Can someone tell me how to do this?

I have a transaction table that has fields such as Date, TransactionNumber,
ItemNumber, Quantity and Amount.  It is data taken from a transactional
system and imported in Access.  The ItemNumber fields can have values of our
Item Numbers such as 3142 or it will have the value of ...

I have this query.
Select VO.idOperation,G.Description AS Group,VO.Active,
    count(VO.idOperation) as tot
from TB_ViaturOperation VO

I have a query and require to filter it using a value set in a form. (this
part i can do)
however if no value is selected in the field i want the report to show all
records that do not contain a blank/null.

I need to produce, from multiple input records, for example Gross  - Taxes
withheld - Deductions Withheld - Employer Taxes - Net where each input record
will contain one of the above amounts identified by an "Amount Type".  This
will be used to populate an Excel Spreadsheet for ...

i have a datediff field that gives me the age of students. I need it to be
quite exact so it gives it to me in 2 decimal places. How can i change this
to be a fraction
e.g 8 1/2 years old

I'm using the evaluation version of Office 2007 pro. I have an application
that I was using seamlessly under access 2003 version. When I run it under
access 2007 I find that some queries fail to execute replying the message:
Error reservado (-1524); no hay ningún mensaje para este ...

I have details of investments made with maturity date starting from 2004. I
want to get a report for investments made in 2006/2007 and investments that
are maturing in 2006/07.

I need to have numbers such as 1.00001 or 1.5, or 1.95843 all round up to the
number 2.  Can anyone help me with this?

I have written some VBA that (among other things) writes the SQL statements
associated with all queries in an Access database to a text file. The SQL is
retrieved in this way:
   For Each aQueDef In CurrentDb.QueryDefs