So confused on Tables and querying

[Guest]

Hi everybody,

I have a table that is used for all kinds of reports. it was found that a
field in the table is inaccurate. A seperate query actually can get the
correct data. I would like to update the records in the table based of the
results of the new query. I have no clue as to how to do this. I would
apprecate any advice. it would not be fun to manually update the field

Jones

 

[Guest]

When you use the term inaccurate? What specifically is wrong?
Up-date what? -- To what?
See Append Query in your Access Help files and if you have specific
questions please post them to the Discussion Group.

 

[tina]

I would like to update the records in the table based of the

results of the new query.

to update data in existing table records, you can use an Update query. (an
Append query adds entirely new records to a table.) as a general
instruction: write that "separate query...[that] get the correct data",
then turn the query into an Update query. note that the destination table
(the table you want to update) must be included in the query. suggest you
read up on Update queries in Help.

hth

 

[Guest]

I fully agree with the update query. Thanks for that correction

I would like to update the records in the table based of the
results of the new query.

to update data in existing table records, you can use an Update query. (an
Append query adds entirely new records to a table.) as a general
instruction: write that "separate query...[that] get the correct data",
then turn the query into an Update query. note that the destination table
(the table you want to update) must be included in the query. suggest you
read up on Update queries in Help.

hth

Hi everybody,

I have a table that is used for all kinds of reports. it was found that a
field in the table is inaccurate. A seperate query actually can get the
correct data. I would like to update the records in the table based of the
results of the new query. I have no clue as to how to do this. I would
apprecate any advice. it would not be fun to manually update the field

Jones

 

[John Vinson]

Hi everybody,

I have a table that is used for all kinds of reports. it was found that a
field in the table is inaccurate. A seperate query actually can get the
correct data. I would like to update the records in the table based of the
results of the new query. I have no clue as to how to do this. I would
apprecate any advice. it would not be fun to manually update the field

Jones

As noted elsethread, an Update Query will do this. HOWEVER - if the
value can be calculated, perhaps you should just calculate it every
time and not store it in the table *AT ALL*.

If you're making the common assumption that you must have all the data
in a Table in order to put it on a report, be aware that this
assumption is incorrect. It's just as easy (and very common) to base a
Report on a Query; and that query can include calculated fields.

John W. Vinson[MVP]