So I'm nearing completion of this extensive (well, extensive for me)
database, much thanks to all of you. I'm working on the last parts of the
report, and I've run into a problem:
I need to total the number of hours spent cleaning different types of roads

I am using Access 2002 and I want to query  a date field called completed.
Now this field may not be populated.  How does one query a date field that
is not populated?    For example one record has 12/10/05 in the completed
column, which I don't want I only want records that the ...

Using Access 2000. I have a form with a combo box and a command button set to
open a query. The query criteria is Forms!FormName!ComboBoxName. I also tried
putting Forms!FormName!ComboBoxName in the query>parameter but that didn't
help. My problem is when I press the command ...

I have set up a query that has several tables associated. (All the tables are
linked)
tblProjects - pulls basic project information
tblBAIRCV - pulls option group value description (based on option group

I am new to IIf statements.  I am creating a field that will be called
"Income".  It's value for a property would be the rate in the field "Rent" if
the field "Available" is NO, but it would be 0 if the field "Availabe" is
YES(meaning the property is not rented and therefore not ...

Let see if i can explain this right.
I have a file ran from our IT depart that includes all the invoices and all
the payment for all customers.  We are doing mass write-offs anything over
181 over.

Hi, I have two large tables that need to be combined, Original and 01_16.  
The two fields in question are Original.Company.Name and 01_16.BusinessName.  
01_16 has the data that needs to be added to the records in Original where
the above tweo fields are the same.  The problem is ...

I have 4 different queries based on one column of the same table.
What I need is to create a report that will give me the total amounts of my
4 queries, and that can compare it to a grand total (translated in %of)
How do I do this?

How do I get multiple values in a cross tab query?

I have a table with a list of offices and tasks that go with each one.  I
have a querie that prompts a user to enter an office number to pull up only
that offices tasks.  Is there a way I can make the prompt ask for multiple
offices?

Ok, here's the dilemma.  9 variables in drop downs on my form that
am using as values for a parameter query.
In my criteria for one of the fields in the query there is:
Criteria: [Forms]![Sort]![Contact]

I just recently started working on a new db.  When running queries all fields
are displaying instead of just those that I selected in the design of the
query.  I haven't seen this before.  Is there something I can turn off so
that this "show all fields" does not continue to ...

I have converted my dabatase97 to 2003 and now I am getting ODBC Call Failed.
Here is SQL string failing.
PARAMETERS [forms]![Curr_date].[Beg_Date] Text ( 255 ),
[forms]![Curr_date].[End_Date] Text ( 255 );

I'm so frustrated.  I have a very simple, yet large database (because of the
# of records).  I have an append query that tries to append approx. 10,000
records to a table that contain anywhere from 10,000 - 50,000 records.  It's
a very simple append query, no calculations, no ...

Access 2000 SP3
Win XP Pro
I have a SELECT query that finds a value based on a date. I'd like to find
the same weekday's value for the previous year - so not the same date but