G
Guest
I'm need some assistance
I'm have this table that is importing 35 files, every morning.
these are the fields of this table
FILENAME,BATCH#,TRANS TYPE,CARD NUMBER,AMOUNT,AUTHo#,CASHIER
I need to append these files to another table, but the File name has to be
broken into 2 fields
File Date and Location.
an example of the FILENAME field is "PB010830", where "01" is the location
and "0830" is the
file date. I need to somehow break the whole name into these two fields but
what the location field has to be 4 digits, the number "78" has to be there
and then the next two.
now for the date field, it has to be xx/xx/xxxx format.
Just want to know, when i am appending all this new info onto the new table,
can i group all the data.
I have this statement that will search the batch #'s, only taking the first
4 digits, and if they are the same, they
will combine all teh same numbers and total their amount. Do you think if
what I ask for will effect this statement.
Thanks
I'm have this table that is importing 35 files, every morning.
these are the fields of this table
FILENAME,BATCH#,TRANS TYPE,CARD NUMBER,AMOUNT,AUTHo#,CASHIER
I need to append these files to another table, but the File name has to be
broken into 2 fields
File Date and Location.
an example of the FILENAME field is "PB010830", where "01" is the location
and "0830" is the
file date. I need to somehow break the whole name into these two fields but
what the location field has to be 4 digits, the number "78" has to be there
and then the next two.
now for the date field, it has to be xx/xx/xxxx format.
Just want to know, when i am appending all this new info onto the new table,
can i group all the data.
I have this statement that will search the batch #'s, only taking the first
4 digits, and if they are the same, they
will combine all teh same numbers and total their amount. Do you think if
what I ask for will effect this statement.
Thanks