I have two tables: WorkOrder and Defects with a one to many relationship.
My query results are like the following
         WO#               Defect
         1111              Bad Shrink

When I run my query I have some blank feils.  I would like to have those
fields to contain a zeor instead of being null.  I've tried writting an IIF
statement but programming eludes me. Please help.  Thank you

I have two tables.  Both of them have two feilds DEVICE and QTY.   They are
linked together in the query by the device feild.  The same devices are not
always in both tables.  I would like to be able to have all of the devices
shown when the query is run and the devices don't ...

I have a query that is currently automatically hiding duplicate rows. What
do I need to do to set it to include the duplicate values?
Thanks.
Filo

I'm writing, in Access 2003, a select query in which the source table is in
an external database protected with password, that I can't link to for other
reasons.
My last try was:

I am getting stuck on the SQL code to do this.
What I want to do is Prompt a user for input a value for "City" on table
"Shipping" and update the field City on table shipping to this new value.
there is an ID feild that will always be set to 1.  

I have tbl_bundle which lists all of my bundles.  I have tbldocinput that has
all of the documents or records in the system.   Many records are related to
a bundle.
I want to do a query whereas I can have  a count of bundles assigned

I am trying to build a database that is used for a HOTEL.  I have a
table that has two fields DateIn and DateOut.  How do I get the days
in between to show up in a report.  For example if  a guest checks in
on 1 Oct 07 and Checks Out on 9 Oct 07.  How do I get it to show

I have a cross tab query that I want to only pull info forma parameter on a
form.
On the form ir will ask you for 6 months and I want the cross tab query to
only pull those 6 months, however they will change all the time so I want to

I need to write a query that looks like:
[Trans Date]<{2006-09-30} .And. PAYTO="6704aa" .Or. PAYTO="1337aa" .Or. PAYTO
etc.......
There are over 400 "PAYTO" codes I need to enter. These codes are contained

Greetings all
I need to create a query that will add 30 days to another date field every
month. I need assistance with the expression.
As always, thanks in advance

How can I update a sequence of field's contents from one table to a sequence
of seperate fields in another table.
For example
Master Table

I have two "sub"-queries that each yield the correct set of data from each
of two sets of source tables.  These tables have some degree of commonality
(but are not "related").
The field (column) names in each of these two queries are identical to one

I have an extensive mailing list that I'm tyring to normalize somewhat ...
I'd like to create a table with just the addresses and then another table
with the residents' names.  We have three kinds of "residents":
1.  Married couples or families with the same last name

I'm still pretty new at Access but it appears that whenever I execute a SQL
command, Access displays a message telling you what is about to occur.  For
example, if I'm executing an INSERT query, Access display a message
indicating it's about to insert xx rows.  Is there a way to ...