Hello, I'm tring to run a query that calculates total # of days. I have two
fields [Scarif Date] and [Stratif Date]. I can have a value in either one or
both or none. [Plant age] would capture the # of days.
Example

I have a form with StudentInfo, PaymentInfo subform, and CompletionInfo
subform. We invoice a certain customer and then go back and fill out the
payment information when the client pays.
I tried to run a query so that I could make all the updates without having

I am getting constant error messages on Save ("Invalid Argument") in query
design mode, but the query runs without problem. I have tried removing fields
one by one, reconstructing the query field by field (there is only one table
- I want to create a new table using only some of ...

As an example, my input table and output result as below
Date               AA BB                              AA(1+2)   AA(3+4)  AA
(5+6)
090308           1    0.2                                0.6          1.1

Can anyone help? I have a query that has 3 fields Employee Name, Position
Name and Work Instruction Name. An employee is allocated 1 to more positions
and each position has several work instructions to it. I wish to be able to
group (if this is the right terminology) by name and ...

I cannot get the Not Like criteria to work in the Absence field, I try to
delete the filed and replace it with another name to no avail I try other
filed and it works fine.
Why?

I got the following query.
The thing is that I would like to order the results in order of
popularity and then distinct it so i dont have repeating results.
Problem is these two conflict each other so I dunno wot to do.Could

I have a query and I want both the results I get with option 2 and option 3
which as I understand is the left and right join.
I'm told its possible however there are only three choices.
could anyone advise me - its really something I need

I have a query that has a field that for some records it's blank while
others it has information. Is there away to pull the records that have
information in it so for example:
1

Is thre a way to find out what make table query created a table? For example,
I have a table that I created a month ago but can not remember what make
table query I used to create it. I have access 2003.
Thanks for your help.

I have the following Expression in a query, Hours earned: Sum([Qty]/[UPH])
I want to add an IF statement that says if the value in UPH is 0 then
Sum([Qty]/[UPH]) = 0 , write now I’m getting a message that says “Division by
zero”

Currently I have a button on a formA that opens formB.  FormB is based on a
crosstab query that I want to use a field in formA to query upon.  I have
tried this several times and get the error of the Microsoft Jet engine not
recognizing the field on formA.  The help states that ...

Unable to use find a form with access 2007.Worked fine before I upgraded from
access 2003. How can I fix this.If I open 2007 and save as 2003 I can use
find a form so it must be setup right. Is this a Mircosoft issue.

The primary key in the customers table is an AutoNumber field type. I
have a form which is to perform a search from a textbox named
CustomerSearch and is to be compared to the CustomerID in the table
until it finds the CustomerID or reaches the EOF.

I have an Access 2003 database.  The main table get its data from another
system (downloaded) of which some of the number fields come through as text.
Class (refers to number of students in graduating class)
Rank (refers to the students' ranking position in graduating class)