subscript out of range? multiple table report?

[alphadawg]

Is there a way to get the results from a multiple table query into a report?

I have Staff_First_name, Staff_last_name, Staff_email and Staff_tele_no from my Staff table.
I then have Event_trip_title and departure_date from my Trip table.
My multiple table query shows a member of staff and the trips they have been leaders of.

I have tried using the wizard to make a report from this, but it doesn't accept me to choose all of the fields, only fields from one table. Help?

 

[alphadawg]

I rephrased the question in hopes someone can help me

 

[Beetle]

I can't say why you're getting a Subscript Out Of Range error when creating a report, but it sounds from your post like you have created a query that joins the tables and displays the expected results. My question is, when you try to use the wizard to create the report, are you selecting the query as the record source, or are you trying select the individual fields from the separate tables (which shouldn't be necessary if you already have a query that joins the tables)?

 

[alphadawg]

I'm using the query.

Is it possible or impossible? Because if it's impossible maybe that's why im coming up with the error. The query works fine, by the way.

 

[Beetle]

It's very common to use a query as the record source of a report (or form), so there's something else going on here. Have you tried creating the report manually?

When using the wizard, at what point in the process does the error occur?

If you want, you can post your db here (with any sensitive data removed or course) and we can take a look at it.

 

[alphadawg]

The error occured when it prompted me to choose which fields i want to be included on the report from the query. It let me choose fields from one table, but not both.

But I think i've solved it -
I tried a couple of things and found it is possible to choose one table's fields in the wizard, and then the input other table's fields manually. It appears I have to work around it this way!

I just find it baffling that you cant put all the fields in there from the wizard :S

ah, the pains of access.
Thanks for your willingness to help anyway