Advanced Reporting Syntax's

[Guest]

Hi

I have No clue where to begin

I would like to know if I can do some Advanced Reporting pulling unbound fields on a form and sub form

The reason for the two levels is that the 1st form is based on a Query that sums all queries by date giving 1 daily total, then the user needs to input additonal numbers to another table which compares the two systems of total cash

Please provide clues or leads or basic syntaxes to call up the fields....
e.g. [Mainform].[form].... (Something like that I saw

Please and Thank you

Jole

 

[Marshall Barton]

I would like to know if I can do some Advanced Reporting pulling unbound fields on a form and sub form?

The reason for the two levels is that the 1st form is based on a Query that sums all queries by date giving 1 daily total, then the user needs to input additonal numbers to another table which compares the two systems of total cash.

Please provide clues or leads or basic syntaxes to call up the fields.....
e.g. [Mainform].[form].... (Something like that I saw)

To get a value from a control on a mainform :

Forms!formname.textboxname

To get a value from a subform control:

Forms!formname.subfromcontrolname.Form.textboxname