As always, it would help immensely if you posted the SQL from your queries.
If you run an update query, then the values are going to be changed in the
table. If you want to report what the value was before the update, you need
to reverse your calculation:
OldValue: [CurrentValue] / (1 + [PercentIncrease])
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Ilona Wright
Sent: Saturday, May 13, 2006 12:26 PM
To: [email protected]
Subject: RE: [ms_access] Query Help Please
Hi John,
Another question.
What I want is
user inputs a % value and a date
I run a query (qryA) on my assest table selecting records according to this
date and amongst other fields in the query I have
Replacement Value off the assets table and an _expression_ that shows the
result of increasing the replacement value by the % input. This is displayed
in a subform for the user to see the what effect the % increase would have.
I then run a COPY of this same query, except it is an update query.
Up to here it all works well.
I then want anothery query where qryA is joined to the assets table on
AssetId so that I can report the before and after update Replacement Values,
ie, the "before values" off qryA and the "after values" off the assets
table, but the Replacement Values I pick up from qryA are the after update
values. It seems that qryA runs again. Would this be correct, ie is my
thinking right? Is there anyway of preventing it from running again and just
using the data resulting from the initial run?
Thank you John
Ilona
Adelaide, Australia
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
