Query from updated table - question

[timmy457]

Hi,

In my database, there is a table ("Price") which is updated from another table (End-user price). I try to make a query from upated "Price" table, but the result of the queriy is still data from the original/un-updated "Price" table.

I tried to make "make a table query" from the updated PRICE table, too, but still the result still shows the original/un-updated table. I use Access 97.

Could you please help to solve this issue?

Thank you,
Tim

 

[John Big Booty]

Welcome to the forum. If you are able to post a copy of your DB, someone may be able to help you out.

 

[MSAccessRookie]

Hi,

In my database, there is a table ("Price") which is updated from another table (End-user price). I try to make a query from upated "Price" table, but the result of the queriy is still data from the original/un-updated "Price" table.

I tried to make "make a table query" from the updated PRICE table, too, but still the result still shows the original/un-updated table. I use Access 97.

Could you please help to solve this issue?

Thank you,
Tim

A Second Welcome to the Forum!. As John Pointed out, posting the DB will provide an easy way for us to assist you. If posting the DB is not an option, then posting the Query and the Table structures for the tables involved will help as well.

 

[gemma-the-husky]

your update query clearly isnt working correctly

can you post the sql for this?