Search results

I have a report that calculates cost per crash and each crash location is grouped. In my footer I have Total crashes per location and total cost per location. I need the report to group descending by location with the total cost per location being the descending factor. (ie I want it to show...

IT"S WORKING!!! Finally! I went back as you suggested and somewhere along the way, while I was changing and trying different things, I left out the =1 command in my unbound text box [text99]. It works like a charm. Thanks so much for being patient and working with me. I have learned a...

I haven't had a chance yet, there was a family emergency. I will let you know as soon as I have a chance to try it. Thanks so much for your help. ;)

option 1 gives me an error message and option 2 reverts back to numbers. Any other ideas? I know it is close!

Almost there! Thanks R6Flyer. I am still having a bit of a problem in that my return letter comes up all "A". I created a table called Pick Letter, and set a numeric primary key. The two fields are ID and Letter. In my new textbox in the detail section I put the following in the criteria...

I have a report that is used to guide readers thru a diagram that uses sequential letters to indicate specific auto crash data. I need the report to alphabetically "number" itself when run and start over at "A" with each new group. Right now it is numbering fine, but is not starting over with...

I have 10 fields that represent individuals in car crashes. In each field, one of five possible answers might appear - A,B,C,K,N (Which represent injury code). I need to create a "total" field for each letter and by individual record - so for every crash number I need to know how many A...