Search results

I am trying to create a reference tree. Basically, when we get a customer, we will usually get at least 5 references. Sometimes, one of those references becomes a customer or was a former customer. What I need to do is make some sort of sense out of what I have available to me. Basically, I...

I posted this in Queries earlier... thought I would try here as well. The scenario - I use MS Access to access an advantage database system from a program we use. I can either import or link to each table in the program's database via OBDC drivers. The problem - I need to track the status...

The scenario - I use MS Access to access an advantage database system from a program we use. I can either import or link to each table in the program's database via OBDC drivers. The problem - I need to track the status changes of our customers. Tracking customer status changes are not recorded...

In my Accounts table I have a field called Status. This field is populated by single letters. A=Active, P=Paid and so on. I have a status (R) that is occasionally used. It won't show up in my crosstab queries since we currently do not have an account that is in R status. How can I get my...

I have a db I set up to autoexec every time it opens. I have set my windows 2000 server scheduler to run the db at 5am, 11 am, 5 pm and 11 pm. Part of the macro is to update a table so I can keep track of what was outputted at that time into the excel files. My problem is that at the 5 am run...

I've created a database that accessess tables from a program we use which is constantly updating with customer information. My database is set up to automatically run 5 times a day to basically take a snapshot of certain financial items at that time. During this automation a query is updating a...