Search results

Working Now, Thanks

When I click the button it's supposed to open another report, instead it prints it. Here's the code" Private Sub cmdGraphTotalBilled_Click() DoCmd.OpenReport "Graph Total Billed 24" End Sub I've used the same function in other places and it works fine.

It's working Thanks a ton. Would you mind explaining to me exactly whats going on in the code though? And Ron, What is the problem with having a "/" in your field names

I have a bunch Facilities I go to, and Some data about each one. I wanted to know how I would be able to calculate how much above the average a facility is. ex: Here's my Query Result right now: Facility Average P/H A-----------3.5 B ----------3.67 C---------- 3 D-----------4.1 I want to be...

I figured it our, while the tables had joins the queries did not, thanks a ton for your help

I related the tables based on date and I tried the join going both ways it still doesn't work

I have two queries pulling data and manipulating it based on two separate tables. The Queries are each grouped by month and year and so info for the last 24 months. I am making a 3rd query that takes the data from each query and manipulates that. However when i do this it multiplies the entire...

I'm not sure if you know sql or want to deal with it, but if go into sql view, where it says select (Insert what ever field the number stands for here), proceed it by the function Sum. Then at the End of the code type "GROUP BY [Client]" So the code should look something like this: SELECT...