Recent content by andrewhanna

I have a single table with information for a call tracking system. Most of the information is yes/no. I need to be able to total the amount of yes' for each column within a date range. Right now, I have about 100 queries to try and accomplish this. However, I am almost certain that this can...

I have to be entirely honest with you, David. I don't have the time to re-write the database. Whenever the database is changed like that...I have to re-write the program. But I am coming down to the wire. Is there no way to figure out the queries and so on without re-writing the database?

Thank you for all the help David. I really appreciate it. I will take a look at it and try to figure it out. Thanks again. Andrew

The data that is currently in the database will be deleted. The program that I built in C++ writes all the data to the database. Now, it works like this. The program is for a sexual assault centre. So, no names are ever used or any other personal information...just the stuff that you see...

Okay, here it is. I have written a C++ program to track calls. Now, the end result needs to be a report. However, I don't have the time to code a report window from scratch for this application. Most of the fields in the database are yes/no fields. However, there are also some combo boxes...

I am using Access 2000 but there are about 100 queries in the database. The main query calls the others to order them for the report. I had to split up that query because it was too complex and now it works, with about 30 other queries attached. But when I try to do another one...it gives the...

I don't know a whole lot about Access or SQL queries. The error is supposed to mean that there are too many JOIN's or the SELECT statement is too big. I broke down the query, and now when I put anything into the new main query...I still get this error.