Recent content by NoFedora

Interesting enough if I look under Loaded Reports the third query I have there doesnt show, only the first two.

No I am in the DETAIL section of the report. The only other thing I notice is when I go to expression builder, under the database name, it shows TWO of my queries, but not the third one which is the one giving problems. I have set up relationships between the queries and the fields in the ain...

My thanks in advance to anyone who can answer this question: I have a query which is adding several fields of data together and then a report which is displaying the result of that query. I have this set up and it works fine for two distinct queries. However, a third query which looks the...

Ah no. The shovel tests and the test pits are separate. a shovel test being just a small foot around hole dug by shovel or post hole digger with no concern for level. They are usually done in a row/column method and are just to see if anything is present. A test pit is a carefully excavated 1...

Each dig site has a name, XXXXXX, that is assigned by the state. After this, a dig site can either have had shovel tests done, or test pits dug, or both. The shovel tests are done with a row, number coordination, ie test row 1, hole 1; test row 1, hole 2 and so on. The test pits go by level...

Ok. I will give this a shot. I THINK I understand what it is suppossed to look like. :) Thanks for everyone's help.

Ok. I understand how to SHOW the totals in a field on a form but there are a LOT of fields. Ie must have 5 different categories. Three Prehistoric and two Historic and each has upwards of 30 items each. I want to show Totals for each prehistoric category and historic category. Then a total...

Hrmm. Why is it a bad thing to store the totals in the table? And are you the scott Farcus from 'A Christmas Story'? :) And Liv I think I know what you are talking about and I will give it a go.

Hopefully, you guys won't laugh at it's simplicity but here goes... I have One table in Access which has a LOT of fields. It is an archeology datasheet which needs to keep track of all of the types of materials found in a test pit dig. ie.. Number of Pipe Stems..... 5 Number of Pipe...