Some of the cells in my table are empty.   If they are empty I want to
replace them with a value of zero.

I have 2 forms linked to the same table but they show different fields.  I
added a button to each to flip flop between views but if the first form
doesn't close I get an error that the record cannot be updated and a few
records have gotten corrupt because of this.

Is it possible to make an "update query" to roll back year to date overtime
hours?   I have an tblhours that totals all overtime hours worked and refused
in which I have ran queries to sum all of those.  Once a year we have to
rollback the year to date overtime hours which means ...

I have a database in which I need to create a query that will give me the
count on days from the day they were opened until they have a status of
closed if they are not closed then I need a count on days for how long they
are open up until todays date.  I am not sure if I can do ...

I've Inserted these fields from a FORM except the AgentID which is the
primary key for the table.
The AgentID equal the first letter of the firstname, middleInitial,and
lastname.

I've wrestled with this one, but can't quite manage it!
I have a tblStatement containing fields StatementID, Date, Description, and
Value. For all records with Description = "NATWEST BANK", there are two
values for each particular date. What I want to do is update the Description

I have a complicated query that is driving me nuts.
Is there any way to keep AND statements together within a single field in
query design? Access is automatically splitting the AND statements into more
than 1 field. Even going into the SQL statement, it is still splitting the

I am trying to create a query which will take all values from table
Names Field Pre and compare it against table AllNames field Name.
Problem is there will only be PART of the name in the Allnames field.
What I have attempted was variations of this and I haven't been able

Good morning,
I have a listing containing the following data:
PT     CONTDTD    VISDTD
100100001     20030430    20020417

I have a form frmSite with a subform sfrSiteMaterial. On the subform is a
textbox txtProjNo.
I want to generate a report which uses as a datasource a query. In the query
is a field ProjNo. I want to set the criteria in this field to refer to the

I have a query that runs to calculate to cost per attendee at a
function. The expression I use is:
CostperAttendee: IIf(Nz([Total],0)=0,[Cost],[Cost]/[Total])
It runs just fine and gives me the cost per attendee but I want to add

Is there away to minus time in hours beyond [CheckOut]-[CheckIn]

What is the expression to calculate a weekly rolling total?
Week    Amt    Total
1/1/07  100     ---
1/7/07  125     225

I have a series of 10 crosstab queries that gather various per month counts.
The output of each crosstab is:
1   2  3   4  5   6  7   8  9  10  11  12
#  #  #  #  #  #  #  #  #  #   #   #

I have built a query which has lots of information based on the same ID. THis
ID can have reads taken on it at any time and therefore the table I have has
many records all with the same ID but with a date saying the latest read.
Is it possible to only select the latest read date ...