Recent content by chiefman

The reason I need to unbind it is because it prints the data for each record and I only want certain records. When I try to filter based on text boxes on the report (ex. Me.text1<=![date]<=Me.text2) it always asks me for the value of text1 and text2. Maybe I have the syntax of that statement...

I have another question about this report. I have to be able to set it up based on a date range that the user selects. I do this in other reports in the code, however all the code does in this report is set the size and position of the objects, not control which records are displayed. When I...

Thanks. That worked. I had to tweak it some because of the odd way that Access wanted to do it, but your idea helped a lot. Thanks again.

I am creating a report with a graph. I have a query that the graph is supposed to use for its Record Source.When I go into datasheet mode and view the query results it asks me for the values of the text boxes and I get the correct data. Nothing unusual there. However when I run the report I get...

I wasn't asking you to read my mind. I was stating a secondary problem and asking if anyone has ever come across anything similar. Or if anyone knew of any other ways to specify criteria to a graph besides putting it directly into a query.

I may have to mess with that some to get it to work, but I also have a combo box on the date select form that has possible values of "All","Weekday","Weekend","Saturday","Sunday","Holiday".This is in turn passed to the report and stored in a text box on the report. Any idea how I could do any...

Ok, thanks. I'll try to plug it in to the query and see what I get. I've never like parameter prompts either, they leave too much margin for error.

Does anyone have any idea how to get a graph to accept a date range from another form? I have to generate graphs from selected date criteria. I'm generating my graphs based on queries and I pass the criteria to the report from another form using text boxes that display the date range info at the...

Thanks a lot. That did it.

Sure. Turnover_Time is the time between patients. It has to meet other criteria to fall into this category, but it's calculated in another module. ORID is the operating room number. What I am trying to figure is the average turnover time per ORID (OR_Suite_Number). The table contains the...

I am creating a query that has to calculate the average time that a hospital room sits empty before the next case is brought in. I need the average for each room and right now my query is giving me the average overall, instead of by room. Here's the query: SELECT PerMonInput.OR_Suite_Number...

Ok, I have it working for my overall data, now I just have to figure out how to break it down by categories. That is correct about the format function, I didn't even think about changing the name. However, I am using Format([Date]...) instead of Format(Date()...) and it's working, I just have...

I may have figured something out. Let me play around with it a little bit and I'll let you know. Thanks again for your help.

It actually was showing 2 values on the X-Axis. "Yes" and "No" and was displaying the count for both. Then I added the extra criteria and it began showing just the count for "yes". However it would never take the date criteria into account, even though in query builder that "Row source" pulled...

When I try what they have my graph disappears and all I get are the title and the border, even if I take that code out it doesn't come back.