Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report by query problem

Status
Not open for further replies.

RickBerem

Programmer
Jan 18, 2001
156
CA
Hello,

I use a form with 2 textbox and one combobox to "build" my query... I ask for a start and end date in the textboxes and in the combobox for a production line number
then the query use this data to fill it's blanks and return the downtimes for the selected line between the start and end dates.

Then I try to run a chart report with this data...
but and up with a blank sheet.

is it possible to link this type of query with a chart report and if it's possible what do I do wrong?

Any Help would be "helpfull"

Thanks
RickBerem
 
does the query return any records?
do you keep the form open when you run the report?

PaulF
 
I do keep the form open when I run the report(it's a print button on the form) and my query returns some records.

any other ideas?

please!
 
I haven't used Chart Reports, so I can't provide any definite solutions. I'd just spend some time ensuring that I didn't overlook something in the way the report was designed, since the query appears to be working fine.

PaulF
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top