Search results

Thanks for the hint. I did go back and work through my fields and corrected the problem. I have necer used pivot tables, but I will take a look at them, because the cross tab so far is the only thing that worked for the report I needed.

I put a post in the General section regarding this, but realy feel the Query is where I should focus. Here is what I need to accomplish: I have a report 3 times a school year that compares the same period from the previous school year. My comparison data is a count of incidents in 10...

To:Pat Hartman and others: I worked out my problem with the adding of records to my database. The things Pat Hartman said to do worked, and I finally worked out my problem with the macro, which was the final glitch. I am very happy with this web site. I will read others questions and learn...

Thanks for the 2 replies. I do believe the probelm is in the join line, but do not know which type of join to use and how to create it. My tables have the following fields: Tbl Main AccidentID - Primary Key (This is the field that seems to have the problem) School Year...

This is my first database. I have 3 tables which only duplicate one field which I am using to create my relationships. I have made sure that the data types are the same in the connecting fields. I used a query to make my form to pull all the fields from all three tables. I get the following...