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 want to thank both of your for you help. I have found a wealth of knowledge thanks to this forum. All of the Access books in the world can't teach me what I have learned from help from all the members.

Thank you for your help. I understand what you are saying. Sometimes I overcomplicate the problem and don't see the easiest solution. I can set the outerjoin query to update my change table with the latest changes. How would I pull it into a report? I'll have a table with acct#'s duplicated...

The only reason I reposted is that I thought the query thread was wrong and the general thread would be better. That said, I didn't know how to remove this post when I posted in the other thread. Thank you for your help.

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...

I may not understand what you're saying but I already have a columns header for my Status. Please see attached screen shot.

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...

Here is what happens: I have my Window's 2000 Server Scheduled Tasks opening the db at those times. (I receive an email that the scheduled task occured plus the reports the macro outputs are updated so I know it's actually updating.) The autoexec macro: TransferDatabase - Transfer TRDATA...

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 decided to make another report I've named test. The control source is my table DailyTotals. I've added one text field just to try out the sql. The sql I've used is SELECT AllActive FROM DailyTotals WHERE PrevDate=Date()-1; AllActive is the amount of active accounts we have at that given...

Have you tried a crosstab query that would add up all the hours for you for each individual?

I have updated my tables to use the proper naming conventions and I also used square brackets. I'm still getting this error. Syntax error (missing operator) in query expression '[SELECT [DailyTotals].[AllActive] FROM [DailyTotals] WHERE ((([DailyTotals].[Date])=Date()-1));]'.

I changed the table name to DailyTotals. Now I get this error. Syntax error (missing operator) in query expression '[SELECT [DailyTotals].[All Active] FROM [DailyTotals] WHERE ((([DailyTotals].[Date])=Date()-1));]'. The report is pulling from a query called totals, not this table. Does that...

Thanks for your help, Bob! I think I understand where you're going with this... I changed out OrdersTemp.* for Daily Totals.All Active where Daily Totals is my table and All Active is the field I want to pull from. I changed OrdersTemp.OrderDate for Daily Totals.Date where Date is the time...

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...