Search results for query: *

Yes. That worked. I could swear I've tried that more than once, but only got the running total for the entire report. Obviously, I had it in the wrong footer. Thanks.

Device Type (Header) Model No. (Header) Detail Control Source =1 Model No. (Footer) Need Total by Model No. Device Type (Footer) Need Total by Device Type Device Type PC (Header) Model No. GX520 (Header) Detail (GX520) 1...

Again, should be easy, but I'm missing something. My report looks like this: PCs GX520 No. 1 GX520 No. 2 GX520 No. 3 Total GX520 3 GX270 No. 1 GX270 No. 2 Total GX270 2 Total PCs 5 This is the number I'm not getting.

Never mind...it worked! :)

UPDATE [Table01] INNER JOIN [Table02] ON [Table01].ID = [Table02].ID SET [Table01].FRL = [Table02].FRL WHERE ((([Table01].FRL) Is Null) AND (([Table02].FRL)="X")); I'm trying to add an "X" to Table01.FRL when there is an "X" in Table02.FRL. It seems simple enough, but I am getting no update...

Table1 Field:StudentID Field:Guardian 1 11222 Jessica 2 11222 Jose 3 11234 Rita 4 11234 John 5 11234 Grandma I need to be able to show ALL guardians for a particular StudentID within a SINGLE...

I have seen several threads on this topic, but none of the solutions has worked for me. I am not a VB guy, but have done extensive work in Access with queries, etc. Here's the specific need: Table1 Field:StudentID Field:Guardian 1 11222 Jessica 2 11222...