RobReynolds
Technical User
I've been using 2 hotfile reports to get billing rates from a billing database into a time tracking database. I am now trying to use Access to eliminate the first hotfile. I have rewritten the 2nd hotfile report using Access to combine the 2 databases. My problem is that if I save the new hotfile a few columns do not verify under Catalog|Tables. All column titles/order are unchanged from the orginal hotfile. Most of the columns are ok but a few are invalid. I suspect the problem may have to do with the fields data type.
On the orginal hotfile one invalid column was varchar(55) and now it is varchar(257). Is this the cause of my problem? If so how can I set a varchar
from a query in Access?
On the orginal hotfile one invalid column was varchar(55) and now it is varchar(257). Is this the cause of my problem? If so how can I set a varchar
from a query in Access?