|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
update or append?
I have a table that has names for the year 2003 and that table prints on a report. Now that it is 2004 when I try to print the report it gives me an error because all the names are under the 2003 year.
How would I do to make all the records for 2003 become 2004 so that my report ( which pulls information from 5 different queries) displays all the names? Do I have to update or append the table with the names and dates or the query which pulls information from these tables? thanks, j 2004 |
|
#2
|
|||
|
|||
|
If you are going to create a whole new set of records for 2004 then use Append
If you want to UPDATE the current set of data from 2003 to now be reference for 2004 then use update query to change the referencing info S- |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > update or append? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|