I have created a asp query to give me infomation about my tables.
For Counter = 0 TO rs.Fields.Count -1
fldName = (rs.Fields(Counter).Name)
fldType = (rs.Fields(Counter).Attributes)

I have two tables. One with data from 1995 up to June 2004 and another one
with data from beginning of 2004 up to July 2005. Both tables have exactly
the same field names with exact same number of fields. I need to have all the
data from 1995 up to 2005 in one query. I used the ...

The issue that plagues me is trying to get a graph to interact with a query
by using a combo box to determine the criteria. The theory being that the
user could enter a page select the item that they wish to view the graph from
and then hit a graph button and launch the graph. I can ...

Did not get any response to my third level reply, so I thought I'd try
posting anew.  Thanks!
_________________________________
Here is the SQL view as you and John Vinson directed:

I have a query using an IIF clause, it works fine. But when I add another IIF
inside, it tells me syntax error. Any idea? The SQL code is as bellow:
SELECT A.[Customer ID], A.[Year], A.[Month], a.reading, iif( A.Unit='L',
IIF(A.Note=‘New Count’, A.[Reading], A.[Reading]-B ...

Appreciate whatever help you coul provide on this.
I've got a table with, say, a text field "subjectName" and two date fields
"BusyFrom" and "BusyTO".
How can I find if "subjectName" is already busy next time I want to enter a

Employer wants a new field (ClosedDate) added to table (QAK1Data) and back
filled from field (EnteredDate) in another table (BillingData) when field
(Closed) in table (QAK1Data) is True. Table QAK1Data hold information for
individual jobs and is indexed on the field JobNo. Table ...

trying to find what is called a west point bridge disigers

How do I include a column in a union query that displays the table name where
the data came from in the row.  For example, I query CustomerName and Amount
from from Table1, Table2 and Table3 and I want the record or row to display
which table it is from, either Table1, Table2 or ...

In queries, if date field is blank, what criteria do I type so that only
information with a valid date will print?
thank you,
JR

I am trying to insert a graph in to a form or report, so I am wondering if it
is possible to export the data to an embedded Excel worksheet in an access
form and create the graph there. I can do this manually by copy and pasting
data in but I would like it to happen automatically ...

Hi again
I have a query problem that I know probably has a simple solution bu
for the life of me I can get it
Here is my situation: I am creating a employee payroll database (sinc

I'm having the follwing expression in a query
B0501C: Sum(IIf([Category]="Budget" And [Period]="200501";[Amount]))
but what do I add to this expression, if I want Access to return 0 instead
of null in cases when there are no values meeting the IIf statement?

I've created a query that caculates a number of records based on an IIF
statement. Now I'm summing these calculations (e.g. month 1, 2 and 3 should
sum to quarter 1) and it works perfectly as long as the initial calculations
contain something but when there are no values in of ...

I have a table with the following attributes:
Customer_Code, Product_Code, Category, Month, Value
Where category has the domain BudgetTurnover and ActualTurnover
and Month has the domain naturally Jan to Dec