Form and report problem

[bacardi451]

Hello,
I am trying to create a report for a form. When I create a report I get blanks. I have two tables. Table 1 has the following field names: Date, Section supervisor, and section employess. Table 1 is used for the main form. Table 2 has the following field names: Time, data entry. Table 2 is a subform on the main form. I need to create a report which gives me the date, supervisor, and all the times and data entry. is there a way to do this. I tried diffrent ways even look in reference books and still can not get this problem solved. Any help be appreciated.
Thanks
Al

 

[aqif]

Hi

The best way is to create a query which gets all the fields of the table. Then make a grouping report and open the Report directly from the form by using the code.

DoCmd.OpenReport _
"MyReport", acPreview, "", "[Forms]![MyForm]![MyID]=[MyTable]![MyID]"

Just replace the appropriate forms and table names and this should do the trick. The main thing is to fix the query. If you are having the troubles in that then mention the field name and relations in your table and I will write the query for you

Cheers!
Aqif

 

[bacardi451]

Aqif,
I tried making a query with the information but it comes up blank. any ideas
Thanks
Al

 

[bacardi451]

Aqif,
I found the problem why it would not show any input in the query becuase I had both tables linked. Now my other question is how do I get the report to show just the shift supervisor once vice all the time next to the entry.
Thanks in advance
Al