Search results for query: *

I was wondering if someone could help me. I have over 3000+ XML files that need to be imported each month into an Access Database. We were able to locate a module on the internet that allows us to import the files into our Access 2000 DB, but not all the data is imported. Can anyone help? We...

Thanks a bunch, I will give it a shot.

Hi there, This might be off topic, but I have to columns in access, a client estimate value and a system return value. I want to measure how far the system return value was from the estimate value expected from a client. How can I do this in an access report? or incorporate it in a report...

Thanks everyone!

Tried that, no format option was given in the drop down.

Sorry that didn't work. Is it possible to use that same idea but use count if... test =" " and if ...test =" "? ps. thanks for all your help. I also have empty fields, so ref to null values might help.

Tried, that, the problem is I need to count how many times that Test X returned a "pass" and Test X2 returned a "pass" for Job A. Hope that makes sense... ?

I have a report that I am building. I have grouped it by company, month and job type and can count how many jobs a certain company did in a certain month. There are 3 job types, a, b and c. Each has 2 tests. Tests can result in pass, fail or noest. What I need to do is count how many times...

Hi there, Can anyone help me. I have a field that contains dates in the format "dd-mm-yyyy" which is okay for double digit months. What I need to do is tell the system to enter a "0" before a single month digit to amend the date from "12-2-2005" to "12-02-2005". I can do it, but only by...