Ok.  I am working with a select queury and all I am trying to do is sum two
numbers in a column together that share the same 'queue'.
For some reason it's adding the two numbers and then multiplying by 17 for
every 'group'.

I have a column named PlannedStartDate that contains a date/time field
(ex:2/29/2008 3:15:08 PM) in another column i want to to show what the
date/time would be in exactly 2 hours.

My query is based on 2 tables (pounds & Hours). Both tables use autonumber as
a PK. Both tables share 5 similar fields:(Year, Month, Week, Location,
ProdCategory) but as you can see none of those fields is unique. The pound
table has additional field (ProdCode) by which the ...

I have a database set up to do quality reviews on files
There are a number of questions with Yes, No, N/A as the possible outcome to
each question.  Each question is set up on the table as a combo box which
feeds off tblAnswers which consists of 2 columns: 1st is autonumber 2nd is ...

hi
i have created a query but for some reason no matter what i name it even
"query 1" access seems to bring up an error message saying " query1 is not a
valid name. Make sure that it does not include invalid characters or

Dear all, I need the help on below;
Colunm1
0.9
0.89

How can I create Primary Key autonumber field by SQL Command?
For existing data start from 1 and end at the end of rows
Example:
Field Name : Id Auto Number (Primary Key)

Any suggestions no how to programmatically examine a QueryDef to discover
where a Field came from?
Candidate properties: Name, SourceTable, and SourceField.
But these do not reliably identify the field.

Using the statement below, the criteria for Cust_Id1 field yields "00001"
records as well as other records not = to 00001. This is a text field. I
would expect all  Cust_Id1 records not = 00001 to be filtered out
Strangely when I run the same query in Access 2002/2003 the criteria ...

I have a query in which there is a date field and a field for a dollar
amount. I want to have a calculated field in which the dollar amount for the
date prior to the most recent date is subtracted from the dollar amount for
the most recent date. For example, if the amounts on the ...

Hi everybody -
I started a database with data that I collected last year. It was all going
fine, until I started entering older (2006) data. Now, when I run a query,
some of my fields are left blank for the 2006 data but not for the 2008 data,

I've imported data from an excel ss that looks like this:
Org A         5        Z
                7        M
                1        K

I am working on yield, I have 2 qureys one for good and the other to sort the
bad in to catagorys. I want to add the total good and total bad for total
tested. Sometimes the results are null. When I add the two fields I get blank
when I should get units tested. Using access  2007 ...

Hopefully you can help with this. I've done the query below to show
records in our call logging system where a case has been completed by
Month.  This correctly shows this data.
However, I need to be able to change two things on it but can't work

Reports are simple in design view but queries are what I am interested
in.
I have not found a way to alter the header information in a query
other than to turn it off.