Pull Fields on to a Report

[Pappy]

I have a form which has a subform that displays the multiple listings of a contract number. I need to print a report letter that contains values of the different fields of the same contract number.

I either need to pull all the information from the subform, or pull one set of info off the form, and the other off the subform. Any ideas on how to do this??? Thank you

 

[Fornatian]

Assuming you have a structure something like:

[Contracts Table]
ContractID(Primary Key)
ContractWith
ContractTel
ContactBlahBlahBlah...

[Entries Table]
ContractEntry(PrimaryKey)
ContractID (ForeignKey link to Contracts Table)
LineEntry
Works
Personnel
Cost
Blah...

and if I am reading your question right you want to pull info from both tables and group the information on the ContractID and ContractEntry fields.

This can be done using the report wizards options.

 

[IgorB]

To Fornatian: Report wizard cannot give you merge info from 2 tables.

You need to use Query wizard first: add 2 tables, joint them by related filed and save your Query.
Then use Report wizard and select the saved query as recordsource of report.

Igor.
With love form Russia.

 

[Fornatian]

To IgorB - you are wrong about not being able to report on two tables in the wizard, you just change the drop down to look at your selected tables and all is well ensuring the relationships are set up correctly.

By building a query you are simply replicating the report wizards SQL builder, unless you want to add criteria or functions, or formats to the query results then you must use the builder.

Although, it is better practice to use a stored query as these run quicker than SQL statements.