reports

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

Im new to access and creating databases in general. I was
woundering how to take information from my form and put it in to a report.

I have a workorder form that pules from 3 tables. workorders,
workorderparts, and workorderlabor.
I want the users to be able to click a view workorder button and a
printable report pops up with just the workorder they where looking at.
Right now all I can get is a report w/ all the workorders listed or just
field lables and no information.
 
Docmd.OpenReport has an argument to pass condition. It is a string that
contain the same as SQL WHERE clause except there is no word "WHERE"
included. For ex., "WorkOrder = ""A-001"" " . So, your job is to generate
this string. Please check Access Help file for details.

Hope this could help :-)
Malee


Josh said:
Im new to access and creating databases in general. I was
woundering how to take information from my form and put it in to a report.

I have a workorder form that pules from 3 tables. workorders,
workorderparts, and workorderlabor.
I want the users to be able to click a view workorder button and a
printable report pops up with just the workorder they where looking at.
Right now all I can get is a report w/ all the workorders listed or just
field lables and no information.
Click to expand...
rights.
 
Back
Top