Search results for query: *

I have a table of zip codes (about 42k of them) and a table of offices (500 or so) we work with. I want to, through a lat/lon calculation, update a field called 'closest office' in the zip code table so that I can identify the closest office for each zip. I have the lat/lon calculation, but I...

I have a delimited text file that is approximately 24 million records and occcupies just over 6 gig of space. I'm working on Access 97, so I knew I could not import the file. I attempted to link the file. I created a spec, went through the file import process, and got a table with the proper...

I am receiving a data file which has 8-10 discrete pieces of information which I am filing into separate fields. However, I have another field, a 'notes' field into which I'd like to insert literals for each of the data points. i.e. if the customer indicates he/she wants to purchase $250,000...

Hi. I have an MS Access database set up to capture and report reply card responses. I have a main file on a shared network drive, and I provide each of the clerks entering data with a local db for entry. They write to a table on the hard drive and at the end of the day, upload to a linked...

Hi. I have an MS Access database set up to capture and report reply card responses. I have a main file on a shared network drive, and I provide each of the clerks entering data with a local db for entry. They write to a table on the hard drive and at the end of the day, upload to a linked...