Hello...
I need help.  Based on the results of a query..I want to have 1 of 2 things
happen.
--If the query returns no data, I want to have a message box pop up and then

I am pulling tables out of Lotus Database to create reports.  The issue I am
having is that some tables have data for a specific record and some do not.  
For example, all of my locations have transaction data, however only a few of
them have any robbery data because they have not ...

I want to run a report from a query or straight from a table.
Is it possible to give the report or query criteria for choosing a specific
table?
I add a new table each week and do not want to have to change the current

I'm reviewing a db sent to me by a colleague.  It appears to have a make
table query in it, with the following SQL:
SELECT tblELR.ID, tblELR.[Effective Date], "N/A" AS [Asset Number],
tblELR.Description, tblELR.Vendor, "N/A" AS [Manufacturer Name], [Amount

i have 2 tables, one with employees and the other with 10 locations (branch
1, branch 2, branch3 etc.).  Each employee must select a branch, but cant use
the same branch twice, so if user1 used branch 5, I want the query to ONLY
show 1,2,3,4,6,7,8,9,10 for user 1. (The ones he ...

Can anybody give me some code for the Docmd.TransferSpreadsheet
command, which i can adapt for my database (or know where to get it)?
I need to be able to create a command button which will export a number
of tables into the same workbook at the same time. Ideally, I would

After parsing i move the values form tblcustomer to tblRequest. There
are too many spaces in all the field of tblcustomer
but they all move good accept field Account number. Below is the query
which i use to move values but it still give me last

I have been able to use the following code to display results on a report. I
am trying to use this same code in a query but I keep coming up with errors
including "Division by zero". Some of the fields will be null and cannot have
a "0" for the value. The result of this ...

My code works, but am I doing something slightly wrong?  If the table
doesn't exist an error is raised.  Notice, I didn't specify the dbFailOnError
option.  
Is that normal behavior?  Is it a difference between DDL and DML SQL, or

I have a query that works as I want except that I want total by
agent by state. It is returning total by agent by state by month.
My query:
SELECT DISTINCT

I need to update a summed value from table WO to table Table1.
In table WO, I have fields: PartNumber,  Quantity, and WONum. The is the
many table.
In Table1, I have fields: Component and TotalQuantity.

I have a query that works fine except that a blank record appears at the end
of the retrieved records. This blank record also appears on the form on which
uses the query as it's record source.
How can I stop the blank record appearing in the query and/or on the form?

I'm running a crosstab query and in my sum column I want it to put a zero if
there is no value.  I know how to do it with regular queries, but am running
into problems with a crosstab.  Can it be done?

I got a table "tCorrespondence" where i have lots of combo-fields linked to
sub-tables.
Somebody told me to store the reference number (id from sub-table) but not
actual text in the fields of main table. Which i did, and all was fine with

Hi buddies,
I'm having troubles to create a table, by a SQL statement, wich one of yours
columns have a default valeu. The statement that I'm executing is something
like this: