How can I create a report for a table that has a sub table in it?

[Guest]

I have created a table with employee details. Each employee may have a
different job title for each time they return to be employed by us.

(employee table)
John Smith
56 hill street
(table within table)
Position held - supervisior
Start date - 1/1/05
End Date - 1/6/05

Position held - manager
Start Date - 1/6/05
Finish Date -

This is working fin on my form, but when I try to create a report it doesn't
work. What do I do?

 

[Allen Browne]

Create a query that has both tables.

Then create a report based on the query. In report design view, use the
Sorting And Grouping dialog (View menu) to create a group header for the
employee.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

I have tried this, and an error message comes up saying " The wizard is
unable to preview your report, possibly because another user has the source
table open in exclusive mode. Your report will be opened in design view.

 

[Guest]

By the way, the query also worked fine. It has a new line for every time the
employee is re-employed and changes job titles. It's just making a report
from that that I'm having trouble with

 

[Allen Browne]

Try closing Access and restarting.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

 

[Guest]

It still does the same thing. The Query worked fine, but when you try to
create a report, it doesn't happen. Actually after you try a report, the
query no longer works either.

 

[Allen Browne]

Frank, you can build the report without the wizard if necessary.

If your query fails after you try running the report, you have something
else wrong in the database. Could be anything from bad code to a corruption.

If you suspect a corruption this article may help:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
The steps for the first symptom would be the place to start.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message