If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can i make query forever read whatever table is currently in u
i have a 'table' (call it A )
2 forms feed data into A a query file 'sums' the fields in A. a report file reads & displays the content of the query file. i want to periodically stop input to A & begin a new group of data into the same fields in a new table. I 'renamed' A to (say) Z i 'created' a new table called A (wizard) the forms appear to input into the new 'A' the query appears to still see the old A(now Z) can i make the query forever read whatever table is currently called A (asssuming its fields are unaltered) if so how??????? i can create a new query file which reads the new table A that seems unnecessary & prone to error ( the query also has 4 'built' fields which hold the result of + and - selected fields in the table ) -- life is confusing so is access |
#2
|
|||
|
|||
how can i make query forever read whatever table is currently in u
Sounds like copying table A, renaming the copy to table Z, then deleting all
records from A would reslove your issue. Rick B "access_confused" wrote in message ... i have a 'table' (call it A ) 2 forms feed data into A a query file 'sums' the fields in A. a report file reads & displays the content of the query file. i want to periodically stop input to A & begin a new group of data into the same fields in a new table. I 'renamed' A to (say) Z i 'created' a new table called A (wizard) the forms appear to input into the new 'A' the query appears to still see the old A(now Z) can i make the query forever read whatever table is currently called A (asssuming its fields are unaltered) if so how??????? i can create a new query file which reads the new table A that seems unnecessary & prone to error ( the query also has 4 'built' fields which hold the result of + and - selected fields in the table ) -- life is confusing so is access |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Force Blank Lines | jnew | Setting Up & Running Reports | 8 | July 21st, 2004 09:45 PM |
Adding records from another table when doing a make table query | Gilkesy | Running & Setting Up Queries | 1 | July 9th, 2004 05:19 PM |
Update another table with a Max record query | Ngan | Running & Setting Up Queries | 2 | June 22nd, 2004 05:01 PM |
Make Table Query | Sara | General Discussion | 4 | June 14th, 2004 09:58 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |