May be simple but I cant figure it out.
I have one table that holds property details and another that holds
appointment dates for properties.  I have a one to many relationship set.
(one prop many appts).

I've read all the posts regarding similar problems and consulted the ms
support /kb/208714; all very informative.  However, I still can't get it to
work!  Any help appreciated.  I have a table with fields Index, ItemNumber
and CumQtyCalc.  I want to add a field to calculate a ...

I have a large table containing several years' hourly climate data
(temperature, humidity, etc...). I want to perfom calculations to convert the
temperature unit (from celcius to fahrenheit) and to do some psychrometric
calculations on the data.

I am using this criteria in a select query:

How can I get the results to INCLUDE blank(empty) fields?
can I use "NZ" in any way?

I have two tables tbl_Invoices and tbl_PaymentTotals:
tbl_Invoices includes
InvoiceNum
InvoiceAmount

I can see what I need at the Pivot Table view of a Union Query.
However, this cannot be correctly exported to Excel.
Although there is a function of "Export to Microsoft Excel",
however, all "detail data" in Access was gone - leaving only the count of the

I'm using Access 2000.
I have a names field that has inconsistent data in it. Sometimes it only has
a
FirstName and a LastName, and sometimes it also has a middle initial with or

Can this be done? e.g. to show cume units in the query
               #Units Ordered    Cume Units
PartA                3                    3
PartB                5                    8

If I'm looking at a specific record in my Query, how can I edit or go to that
same record in my form? If I want to do that now, I have to open the form
then search. Is there an easier way?

I am trying to do a permanent sort for columns using check boxes.  I need to
know the formula for the criteria box

I have a field with a Yes/No data type that uses a field with a check box on
my form.  How do I designing a query to show all records with check mark or
all records without check mark?  I've tried Is Null in criteria field and Is
Not Null but this does not work for this type ...

Hi I am trying to design a query in design view and need to insert the dates
under the criteria. when i give the dates for example as 01/01/2007, it
changes to #01/01/2007# but these dates r not recognised. am i using the
right format? if yes where could i go wrong? cuz when i ...

I am not too sure how to word this, but:
I am attempting to create a database to track job information and pricing.
I have a query that calculates the price of a fixture based on various
criteria.

Please help me to do this. I am trying to make a pivot query using t-sql.
SELECT Area, Total,1,2,3
FROM (SELECT HOUR,AREA,
CASE

I have 4 pages set up on one form with subforms (each based off of the same
table).  When I run the query I have to enter the [month] and [year] for each
sub form.  Is there a way to run a query over a page instead of subforms.   I
am having the same trouble with the report