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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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:2D14996F-45EF-4AE9-B4A6-CDCA82046C66@microsoft.com...
 
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.
 
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
 
Try closing Access and restarting.

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

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

message
 
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.
 
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
 
Back
Top