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]
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.
