How to update table?

[jerry28ph]

I created a query on how to get the TOP 3 most called numbers with count functions. I had my subform on my main form showing the results of that query. How do I save those 3 called number into table. Some fields associated with this TOP 3 values are already saved in my table tab_summary. How could I updates my table with these values?

Please I need some help on this, I appreciated your kindness.

Thanks.

 

[boblarson]

The answer is YOU DON'T. You use the query whenever you require the data as it is something that can change with a minor change of data. Your table would then be out-of-date and not show correct values. Storing calculated data in tables is something that should not be done in 99.9% of the time. There are some rare occasions when it is something to do, but this is really not one of them.

 

[jerry28ph]

So, usually what did you do to get those value of query in order to store it in your table as new record, if you have 3 fields {top1, top2, top3) in table. I just need those values for report.
thanks

Je

The answer is YOU DON'T. You use the query whenever you require the data as it is something that can change with a minor change of data. Your table would then be out-of-date and not show correct values. Storing calculated data in tables is something that should not be done in 99.9% of the time. There are some rare occasions when it is something to do, but this is really not one of them.

 

[evanscamman]

You use the query as your datasource for the report instead of a table.

In almost every case, a query can be referred to just like you would a table.

 

[boblarson]

So, usually what did you do to get those value of query in order to store it in your table as new record, if you have 3 fields {top1, top2, top3) in table. I just need those values for report.
thanks

Je

If you read my response again, it goes with what evanscamman said.

You use the query whenever you require the data