Search results

Ohhh thank you so much... I was getting very discouraged.

I am attempting to setup a user form to add/edit customer data. I have created a combo box to select existing customers to edit. Once I select the customer I want to edit, it returns the value (custID in this case) to the appropriate field. The probelm, the other data is not being returned to...

I have a simple report that lists customers and their AR balance. I would like to have a GRAND TOTAL at the bottom of the report. I am sure this is simple but I can't find the answer in the Access Bible and I am on a deadline. Thanks for the help. :confused:

I tried moving the expression to the right and it still wanted a parameter value. So I got the results I wanted by running another query off the original one. Thanks for the help!! (Now moving on to the next problem... :D )

It is calculated in the query. The field is called PurchaseAmount and I am running a sum. The query generates "SumOfPurchaseAmount". Now that I think of it...I might need to run a query from the query??

I did change the expression to SumOfPurchaseAmount and put it in the field field. When executed, it still is looking for a parameter value. :confused:

Ok. Tried that. When executed it asks for a parameter value. If I leave it blank and hit ok, it returns the result I am looking for. But, I have to turn this project in and would get points taken off. Any other hints?? BTW... thanks for helping me.

When I go to print the query, I would like the field to show $0.00 instead of being a blank. I am testing with the expression "IIF(IsNull[SumOfPurchaseAmount], "$0.00"). I keep getting an invalid syntax error.

Yes, I data type is set to currency for that field.

I am running a query to provide a list of vendors and a sum of the total purchases in dollars. I did change the join properties to include those vendors were zero dollars have been purchased. How do I show $0.00 for those vendors and not just a blank? Thanks for the assist. SunnyGirl :p