I need to be able to iterate a query for as long as it takes until the update
query has zero records to update.
is there any way to continually to run a query so that it will stop when
there are no more records to update?

I would like to design a query that only the names of people getting cards
would appear.  It is indicated in the table and the form as a check in a
checkbox.  I have tried IFF statements but do not know if it is correct to
use them, mostly because none are working

Hi all, I did do a search but could not find answer to my question.
I have a combo box with 2 options, CLOSED or SUSPENDED.  I have a query that
I use to show the current status of all cases. What I would like to do is
have it so if the CASE STATUS is Null, have the words OPEN ...

I'm having trouble using the DLookup function at the moment, and need your
help!
I have a table that contains different mailing destinations, and based on
the weight of the item and dispatch method, it will go a different supplier.

I have a query with 3 fields:  Industry, Vendor, Total amount with vendor.
I would like to show by industry, the top 100 suppliers based on the total
amount with the supplier.

Thanks for any help.
I have a query that I select all, copy, and then paste to Wordpad or NotePad
to make a text file.
It's basically about a 1000 rows of some letters at the beginning, and then

How would I go about displaying a one-to-many relationship between two
tables in a query, using SQL?
I have a table of clients, and a table of injuries; one client can
have several injuries; I want a query that will result in one row for

I am creating a report that looks like a time card.  My input for my
data is via a form that utilizes a duplicate last record.  As a result
my employees names, task (labor control #) and the hours worked on the
labor control # show up in my report as a vertical list.   I am

Any suggestions on how to accomplish a few simple formulas would be helpful.  
The information I have is 52 weeks worth of orders by item, by customer.  I
am trying to calcluate the standard deviation and average for each item.  
When a customer has no order, it shows up as a null ...

I just upsized to a Data Project and my user prompts aren't working.
What's the correct syntax for SQL?
Thanks

Good Day..
I am attempting to use a form to create a data specific report from my data
table.  I appear to have a problem with the query that is running from this
command though.  I am able to retrieve the data when I fill out the entire

hi,
lets say we have a table with multiple accounts.  an account can have
multiple [activity code dates] it can also have multiple [payment posting
dates].  lets say our first [activity code date] is 1/5/2007 and our first

I have a query where I extract a line per order_line. One of the fields
is products_price, but as there can be several lines for a given order,
and I need to set a flag if the total products_price per order is below
a certain limit, I do not know how to add the products_price per ...

I have one employee table with employeeID as a primary key and availability
days as follows:
EmpID MonAM  MonPM    TueAM  TuePM WedAM
1           0           1             o          1          0

Can anyone help me with the following SQL problem?
How would I combine the following statements so they would produce exp2 /
new.  Where and how do I combine them?  Thanks.
SELECT Sum(Total) FROM exp2 Where Date1>='::startdate::' and Date1<=