Recent content by xzquala

just out of curiosity? is it prudent to have a "new" database created for each year? I know it is more work on the programmers side, but it does remove the possibility of duplicate serial numbers with different years not importing properly. Also, would it not be more efficient for the server...

oooh you know, I think I might have bypassed the summary only option every tme, not even giving it much thought at all because the only field access regognizes as summable is the man hours. but I never went past that screen with the summary option on. thank you for pointing that option out to...

Thanks for you suggestions, I will try them out on duty this weekend. btw- when I said import, I really meant it. it is coming from *.txt files. unfortunately, it is tab delimited, not fixed width. but with these hints I should be able to get it right. Thanx

is it possible to add a date format to access so it can recognise the data I am trying to import? the date is in this format: yyyy:mm:dd 24:00:00.000 example: 2002:07:11 21:49:13.137 aka 11 july, 2002, @ 9:49 pm the only part of it I actually need is the date. the data is in a tab...

heya all. First I want to apologize if I seem long-winded, but I could really use some help. Background- the only access I have to the raw data on the server is through ad-hocs, the only way I can save the ad-hoc is text with headers. Then I must copy it to a floppy, and import it into excel...