Can you run an update query without affecting previous records?

[Jen]

I have an existing large database. There is going to be a price increase in
2006. Can I create forms in 2006 using new pricing without affecting the
forms that are currently in the database at the old pricing? I can tcreate a
new Table with the new pricing but how do I get the same form to pick up the
new pricing?

 

[Jeff Boyce]

Jen

It isn't clear how your data is currently structured. This will affect
"how" you do things.

Are you saying that you have tables for each year's data? And forms for
each year?

Will you need to keep track of the "old" prices, as well as handle the new
prices?

Why would you need a new form to handle prices in '06? Access stores data
in tables, so what does the form have to do with it?

More information, please!

Jeff Boyce
<Office/Access MVP>

 

[KARL DEWEY]

Normally there is not a blanket price increase of say 2.5 percent across the
board. If there were you could build forms and build in a calculation for
each box but I think you will get in trouble.
I suggest you add a PriceDate field and update it with the old date -
12/31/2005.
Then create new records with the new price and new PriceDate using an append
query.

 

[John Vinson]

I have an existing large database. There is going to be a price increase in
2006. Can I create forms in 2006 using new pricing without affecting the
forms that are currently in the database at the old pricing? I can tcreate a
new Table with the new pricing but how do I get the same form to pick up the
new pricing?

What do *YOU* mean by "forms" in this context? In Access, a Form is a
window, a tool to allow you to view and edit data in Tables.

If a Form is a printout (what you would get from running an Access
Report), then it will print out whatever is currently in the table. If
you change the price in the table, you'll - of course - change the
price on the printout.

It would NOT be appropriate to create a new table with the new pricing
- instead, as suggested elsethread, you should have an effective date
field in the pricing table to allow you to print a report for the
price as of any chosen date. Could you describe how your tables are
constructed and related? Where is the price stored now?

John W. Vinson[MVP]