Advanced Reporting Syntax's

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

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
 
Jole said:
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)
Click to expand...

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