I have 25 Update Queries with the same parameters.  I would like to create a
script or stored proc? to run them all at once and then have the user respond
to a form, providing the parameters for the update queries and hit OK,
thereby running the script or stored proc.

I am working on a subform called Cheque, which forms part of a form used to
collect payments from clients.
the cheque subform is a continuous form as clients often pay using more than
one cheque and as such most of the details are the same but the amount and

I have a lengthy report with only several fields across - I know that there
is way to format a report into columns but I can not remember how.  Can any
one help?

I have a phone # field that I need to import into another program.  Before
for I create the csv file to import I need to put a 1 in front of each record.
Record #1 = 4025555555
I need to run an update query that will make theis 14025555555

Sorry for the newbie question.
I have two tables. The first one has several fields, two of which are: STCC,
STCC Definition (currently blank, I want to populate this field). The second
table is an all-encompasssing database with all STCC's and their definitions.

I have an Access database that lists multiple items within a text string in a
single field that I want to recode into several binary variables.  In other
words, if a "*STEREO*" is listed, I would like to create a field titled
STEREO that is equal to either 0/1.  How might I express ...

Hello,
I am trying to create a query where I can get all records that are 120 days
past a date. I tried running a query where the date criteria for a
DateReceived is:

I am creating a form that inspectors use to rate houses. On it I created each
item they are inspecting as a field with a yes/no box. The inspector will
inspect several houses by different builders. I need to be able to create a
summary sheet that will count the number of yes's ...

I need to calculate a couple of date-related values, one is a date 6 months
from the start date, the other is the age today.
I can get this information by putting the expressions into a form, but then
cannot use this info to produce reports.

I am trying to correlate/pull historical data from one table based on another.
Specifically, I have one table [50Avg] that has the following fields:
ID    Ticker        TradeDate    DateYesterday
5766    AACE        4/21/04           4/20/04

I have a form with a subform. In the main form(main), I have a tab that sums
the items for each record(So far so good).  QueryCount sums up 5 different
itmes and displays the count total as I want it to.  Here're where I've got
problems. I need the query to look at field [x] in ...

I've run a query but in the results, one of the fields is labeled "Field0"  
How can I change this to the name of the actual field in the table/query?

I need to take 3 fields Name, First, and middle to one field "Name". For
examplre
Name=Smith
First=John

Access 2003 or InfoPro 2003
I am trying to allow any user to respond to a query criteria prompt and
allow him to search for a keyword (typically identified as a *criteria* or
like criteria).  

I have a macro that is clicked daily that imports a .txt file into my
database to a new table called NewExceptions (no primary key).  The macro
then appends new records from the NewExceptions table to a table called
Exceptions (primary key is PartNo, ExceptionDate & Ind).  My ...