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

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" <(E-Mail Removed)> wrote in
message news:0C10902D-18BC-467A-8FE5-(E-Mail Removed)...
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