Report problem - Access 2003

  • Thread starter Thread starter Nadihaha
  • Start date Start date
N

Nadihaha

I have an Access database with many tables, and am slowly building the
relationships and queries etc.

I am tring to create a report that will list what software a particular
staff member has and what computer it's on.

I can get a report that says who has what computer, and one that says which
software is on which computer. But when I try to add software as a field in
addition to Employee details and hardware I get the message "subscipt out of
range" what does this mean and how do I fix it?
 
normally you would want to finalize tables and relationships *before* you
build queries, reports, etc. i'm guessing that you need a table that links
staff members with computers - if a single staff member may have more than
one computer - or just a foreign key field in the staff table, that links to
the primary key of the computers table, if each staff member may have only
one computer AND you don't need historical data about staff/computer
assignments.

hth
 
Hi Tina,

Yes I have a table that links staff to computers. I'm pretty sure that all
the relationships that I would require for this are in place. I can get a
query to produce the information. But i can't get it in a report. Even when I
try building the report off of the query it comes up with the same message.
It doesn't seem to matter which table I pull the info from as soon as i try
to enter the software field it somes up with that message. Yet it will allow
me to do it for each computer
 
if you're able to build a query that successfully links the staff and
computers tables via a linking table, and returns the dataset you want to
see, then try using the AutoReport button on the database toolbar to create
a basic report bound to that query. just click on the query name *once* in
the database window, to select the query object. then click the AutoReport
button on the toolbar. when the report object is created, you can start
tweaking it make it look the way you want - and, in the process, you're
likely to find whatever change is causing the error you've seen. at that
point, we can probably help you work around it.

hth
 
Ahhh cool I will try that tomorrow. Thxs

tina said:
if you're able to build a query that successfully links the staff and
computers tables via a linking table, and returns the dataset you want to
see, then try using the AutoReport button on the database toolbar to create
a basic report bound to that query. just click on the query name *once* in
the database window, to select the query object. then click the AutoReport
button on the toolbar. when the report object is created, you can start
tweaking it make it look the way you want - and, in the process, you're
likely to find whatever change is causing the error you've seen. at that
point, we can probably help you work around it.

hth
Click to expand...
 
you're welcome, and no, the wizard doesn't make very "pretty" reports, but
that's where the tweaking comes in.
 
Back
Top