Is there a way in Access to script a series of update queries in Access
without using macros and without having to define each UPDATE statement as a
separate, named query.
I have seen a VBA workaround described, but this seems to require defining

I am using Format([START TIME]-1-[END TIME],"Short Time") and this
works good, the problem is I need my time in minutes.

I'm working on a financial report and need to get a Year to Date sum
of the values for the fiscal period's that have elapsed.  The table
structure looks like this:
ACT_PER_01, ACT_PER_02, ACT_PER_03, .....ACT_PER_12

I have a database that has a ID's for all my employees.  I want to run a
query that asks me what ID I want, than between what date to what date.  I
have the date thing down now I just want it to have a custom question of
"What ID" I am looking for to be asked before the date, ...

running Access 2003, XP pro sp2
 I have a form that I used an onClick event in checkMar field to
change or add a date to the (DatePay) field.   I have now added an
update query to set the checkMar field to -1

Good Morning,
I had some help early on how to select specific crosstab intersection values
for further calculation, by removing the pivot and transform section of the
query.  This left me with the age, the classification and the total count for

Right now I have a query "query1" that contains 3 fields
[Deal No]      [amount]      [trans_dt]
10000           10                01/01/2007
10000           20                15/01/2007

I have a query that is prompting me for a parameter when I run it.  I can
just click OK and the query calculates the correct results.
Here is the SQL code for my query.  
SELECT SchedulingFundedHrs.VendorName, SchedulingCosts1.Project,

I have built a form that a user can use to evaluate risk.  I have several
queries and reports that work well when the user types in different risk
score ranges.  What I would like to do is build a combo box that has five
entries.  Very High Risk, High Risk, Medium Risk, Low Risk, ...

I have a data base with employee informaiton. I need to find the end of
probation date for the year 2007. I'm not very familiar with setting criteria
and this is one i can not seem to figure out. Any help would be greatly
appreciated.

CaseNo:
IIf(Right([CaseList]![CaseNo],3)="RES",Left([CaseList]![CaseNo],Len([CaseList]![CaseNo]-3)),[CaseList]![CaseNo])
The above is a the calculation that is run on a query, in which I want to
look for values in the 'CaseNo' field which have an "RES" suffixed on the end

I was mistaken on my explanation previously.  The field in table1 is for
tagexpiration (for when the tag is due renewal), not when the tag was
purchased.--
Todd

I have 2 fields in my table
F1& F2
F1    F2
--------------

Can somebody tell me how to delete duplicates from my query.  I know I"ll
have to make another query that only shows unique - but I can't figure it out.
Thanks.
Tammy

I currently have records that have this on a query: 1/19/2007 10:50:00 AM
I want to modify the query to show a new column that is categorized as
"mm-yyyy". Can You help? --
Thanks for your help!