I have designed a basic d/base in access 97. On a form I can select a job
manager and month and then press a command button to run a report of
customers jobs for that selection. Where there are no jobs I get Runtime
error "you entered an expression that has no value. Here is the ...

I need to round up a value in a query to a multiple of 2: Example: 3.14 would
round up to 4, 4.001 would round up to 6. How do I do this using the round
function?

I have a table that I need to update and I have changed this arrangement
too many times to count.  I think this is the closest that I have come yet.
Here is the SQL.
SELECT qa.WONumber,

can anybody help me please

Using Access 2000.  The data for the report is in one table - tblTimeCards.
The critical fields are [ProjectID], [WorkDate], [Description] and
[BillableHours].  For audit purposes, I need to create a report for each
[ProjectID] which will display the [WorkDate], [Description] and

HELP!
(Please)
First, let me explain. I need to enter 3 time ranges that make up a
work schedule, StartupTime, productionTime, ReconcileTime. (Lets call

I have a table that has an autonum primary key and fields of date, meterID,  
reading and volume. What I would like is for the volume field to be the
result of a calculated field of the latest reading for a particular meterID
minus the previous meter reading for that same meterID ...

I've discovered a serious problem in my application.  My app uses an MS
Access ('97) format database to process some data for reports.  I have a lot
of queries of queries of queries etc.  My report database actually links to
tables in a 'real' Access database so that I don't change ...

I have a script to create tables and relationships. It works fine when I run
it using Query Analyzer in SQL Server. However, Access seems to choke on DDL
that attempts to both create a table and set a relation in one SQL statement.
For example, I have found that running just this ...

I have table with two fields,
Field ID1 can repeat but not ID2. ID2 is unique primary key
Both have string data type
Table T1

I have data entered in a field and I need to create a field in a query that
calls on that date and returns the date of the Friday of that week. For
instance if "Entry Date" is my date field and "5/4/2005" or "5/2/2005"is in
this field what formula would I use to return ...

I want to run a query that will automatically change the zeros in a field to
a 1. I know how to do this manually by replacing a 0 with a 1 but I want to
have it in a query.  
Thanks

I need help with an Elseif statement.
Table Name: Modified Report Assignments
Fields:
Fund

I followed all the steps to create a query for autolookup, but its not
working. Would it be the  fact that the unique field is an autonumber? I find
the customer id on the main form and it populates in the subform. However,
none of the other data populates, first name, last name. ...

On my form that shows a list of part numbers, I have combo boxes that filter
for the various fields. The Criteria lines in the underlying query point to
these combo boxes. Some of the fields have nulls. The  Right now my Criteria
lines look like: