Search results

I have a continuous form based on a table to schedule many classes. In a query, I can get a total of the number of students per class, and a total of the number of students per period. Can I reference that query total in my form? When I try "=[QueryName]![StudentTotal]" as the control source...

Why do I now get an #error when I try to view this field sometimes. I realize its looking at a null, but Nz() doesn't seem to work for this. Any other way? I've tried to change the underlying query also but same result. I should be able to have it display $zero when it is $zero, instead of...

Awesome! Thanks!-Brian

Yes I want to place a sum of fees textbox on my form after I already made the form. I see that I can change the form recordsource from a table to a query, but is there another way to do this for only 1 or 2 boxes? In general, I mean, not just this example. Can you have a textbox based on a...

Such a simple question, why so hard to find the answer? I have a form with family info and a subform with their members. Many members of each family pay fees for classes they take. How do I display the result of the query in the textbox? DLookup? I tried that many times and cound't get it to...