Recent content by grebl

Hello again, So I successfully created three reports, one for each chart. These individual reports ran successfully. Then I created a blank report and added all three reports as sub-reports. When I run this report, it prompts me for the start and end date, but then only generates the first...

Wonderful -- that fixed it. Thank you. I'll work on creating seperate reports for each chart, and then combining them into one report as sub-reports. I'll let you know how that goes (if you don't mind). Thanks again for your help. Leanne

Thanks for your response, Rain. I still can't determine what the issue is. The form's Record Source is empty, so I don't believe it's bound to anything. I'm not sure how to verify if there is any value set to the controls. Perhaps I created this input form incorrectly from the getgo. I attached...

Hi RainLover, Thanks very much for your help. I've created a form, frmChartParam, and created unbound text boxes for the parameters I need: txtStartDate, txtEndDate, and txtFacility. I referred to the date parameters in my first two queries and tested them; they both ran successfully...

Hi Everyone, Please forgive me – I’m a novice to Access and would like to ask for a bit of help with my charts. Any advice would be greatly appreciated. I’ve created a customer complaint database. I need to display three different charts, each with a different query for the record source...

Well, I'd prefer to keep the first and last separate. I currently have them separate in the Customer table. What I'm trying to do is have the CustomerID field in the Orders table link to both the first and last name, instead of showing a number. Is there a way to make the primary key split...

Hello - I need some help! I have a table of customer contact information (last name and first name are two different fields) and a table of orders. I've created a relationship to select the CustomerID (random number) from the Customer Table for each order added. I used a Look-Up so that the...