Recent content by Agism

Consider me clueless. Pat - Where is the ColumnHeadings property so that I can list my values? This is exactly what I need if I can figure out how to make it work. Thanks!

Nope, still doesn't work. There has to be a way to create a report that looks like this: LasVegas Tradeshow 6 Corporate 3 Conference 5 Houston Tradeshow 9 Corporate 5 Conference 1 Georgia Tradeshow 15 Corporate 7 Conference...

Looks like I had this problem before and never solved it. I need to use Count instead of Sum, but it is the same issue. Group 1 - City Visited Group 2 - Program / Software Type Detail - Client Number I can count the number of clients for each Program/Software type. Now I need to know how...

Ack! I am going to look at it again. I was just upgraded to Office 2000 yesterday, finally!

Here is the database. I pulled out all the queries, reports and junk that are just "extras". Thanks!

I am a little stumped and could use some help. I can find my way around Access 2000 alright, but recently I have been moved to a new department and they have 97. I can not as easily create and debug the things I want in the database. I am hoping that someone can help me see the forest through...

Yipee!!!! Thanks John for your help. That is exactly what I needed!!!

I am having the same problem. I have tried adding "DoCmd.SetWarnings False" in every location I can think of and I still get the Access warning. Has anyone had any success in working around this?

Thoughts? Any idea for me? Please.

More info... There are 9 tables with basically, the same fields. Each table holds checklist questions for a specific application the user will be QAing. I also have an Audit Table that records all the changes made to certain fields in specific forms. I found this information on a thread...

I have been reading threads about archiving and cloning but I am still lost. What I have are multiple tables, each with questions for a specific application. I need to find a way that users can copy a question from one table to another. Previously users would copy and paste directly in the...

I am a novice as well, compared to all the knowledge on this board. My guess would be to use DCount(). I think the code would be: DCount("FieldName", "TableName", "FieldName = 'Criteria' ")

I believe what Rich is saying is to base your report on a query that only pulls the top 10 records. In the design view of the query, you will see a field in the tool bar that says "All", "100", or something of the sort. If you make that field say "10", then only the top 10 records will pull.

Pat, how would I create a filter for DSum()? I have a report that shows the phone statistics for 3 phone rotations. Rotations 1 and 2 are agreements for 2 different companies. Rotation 3 is supplies. My data is grouped by date. I would like to see the sum of calls for all rotations for each...

I have a database that adds the number of hours an employee was logged in the phone system and how long he was on available, etc. What I did was use queries to convert all the times to minutes, add the times I needed and convert back to hr:mm format. It was some what tedious, but it works.