Hi-
I am trying to add a dreary task to a macro and I'm stuck...
In my Access 97 database, there are 10 or so tables which get refreshed (from an inventory mgmt. package) every few days. I need to append data related to new information only (from ORDER TABLE)to a separate table (HOLD STATUS). The dates reside in the field BILL DATE.
I can manually run the append query with parameter prompts [Enter Start Date] and [Enter End Date] but I want to add this process to the macro which "refreshes" the data in the first place.
In my append query I tried to set the criteria for the field BILL DATE to > Max BILL DATE (in the table HOLD STATUS). Didn't work.
I also tried to append records that were Between (pointed to table/field which listed previous refresh date) and (pointed to table/field which listed latest refresh date). This didn't work either. I'm not sure if this one failed because of date formatting (BILL DATE is formatted yyyymmdd and although I set the refresh date fields to this format, it appears that the date is actually stored as mmddyyyy).
Can anyone help me figure this out? I'm not up on visual basic - I just design my queries in the "design grid" mode.
Thanks.
I am trying to add a dreary task to a macro and I'm stuck...
In my Access 97 database, there are 10 or so tables which get refreshed (from an inventory mgmt. package) every few days. I need to append data related to new information only (from ORDER TABLE)to a separate table (HOLD STATUS). The dates reside in the field BILL DATE.
I can manually run the append query with parameter prompts [Enter Start Date] and [Enter End Date] but I want to add this process to the macro which "refreshes" the data in the first place.
In my append query I tried to set the criteria for the field BILL DATE to > Max BILL DATE (in the table HOLD STATUS). Didn't work.
I also tried to append records that were Between (pointed to table/field which listed previous refresh date) and (pointed to table/field which listed latest refresh date). This didn't work either. I'm not sure if this one failed because of date formatting (BILL DATE is formatted yyyymmdd and although I set the refresh date fields to this format, it appears that the date is actually stored as mmddyyyy).
Can anyone help me figure this out? I'm not up on visual basic - I just design my queries in the "design grid" mode.
Thanks.