I have an order line table that has many order numbers and several lines per
order number. I have to assign all the order lines of each order number to a
specific Driver, route and vehicle. I have been able to create a form that
pulls the information together but it requires me ...

We recently upgraded to Access 2002-2003, and this query used to work. It now
returns 'Invalid use of null"
INSERT INTO [Agency Payee List] ( ACCOUNT, LOCATION, NAME, CODE9997cur )
SELECT DISTINCT payout.CKPAYEE, payout.CKPAYEELOC, payout.CKAGYNAME,

I have a data entry form where the user fills out text, numerical data,
dates, etc.  I created a button in the same form that runs a macro in
background containing several update queries.  At least 1 record changes from
English to some other kind of language or font but it looks ...

I have 4 identical tables with 224 fields each and want to run a union query
on them to get all records but when I run I get the message stating 'Too many
fields defined'.  Clicking help, it says "You tried to perform an operation
that involves more than 255 fields."  Is my query ...

I have inherited a database which contains complex calculations that are
done in 'modules'. They are all under one function called 'returncost'. I
would like to display this field on my query but do not how to do this. Can
anyone help, please?

Hi,
I have a query that I get all my information from. I created a query that
pulls all the info I need and did a Mk tbl with that query. I now have my
tbl. I Created another query that will append any new records that are

I need to create empty fields to use as placeholders for future data input.  
I know how to create a blank text field by doing this: fieldname:"".  Is
there an equivalent expression to create a blank numeric or currency
formatted field?

I have a database of company names and DUNS numbers.  Numerous people made
entries into this database.  Some of the DUNS numbers have four 0s at the
end, and some do not.  For my purposes they all have to be the same length --
either with the four zeros or without them, but all ...

I have created a function to return the windows user's full name (via Windows
API calls). This function is run via a query and returns the name ok when I
am in the data base. However when I try to run this query from a web page via
a connection to the database, I get the message ...

Hopefully this is an easy question. How do you round up a number in a query
field? Excel has the ROUNDUP function, but I can't find anything similar in
Access. Can anyone help?

I have two tables table1 and table2,  one for beginning of year data and the
other for end of year data.
Some accounts are in table one, but not in table 2 and others are in table 2
and not in table 1.  need to make a query to return ALL accounts that are in

I have a query where I am pulling the customer name where it is formatted as
Last, First in most cases.  However, there are customers listed where a
comma is not present and I don't want those split.  I'm using the Left and
Mid function and I need the two new fields not to show ...

I have two queries which are being used to get a count of "Target Met" and
"Target Missed".  Each query has a column for Person and a column with the
count.  What I want to do is bring the two queries together to display three
columns (person, count met, count missed).  When I ...

I have a query that will not display records from fields that aren't required
but are related to a parent table.  For example:
The "TitleID" field relates to the "Title" table's primary key.  This field
is optional and if a user selects nothing than the default value is zero.  

I am working with queries pulling from an SQL linked table.  I'm pulling
orders within a given time period with the below fields.  Each order line
item appears on
a separate line.