Find the reference of a bounded field

grenee

Registered User.
Local time
Today, 03:53
Joined
Mar 5, 2012
Messages
212
I am using the Northwind sample database. On the Yearly Sales report, design view, there are fields: 1,2,3,4. These fields generate information when the report is loaded. Yet I cannot identify the source of these fields.

Normally to find the field references, you select the field then click the data tab of the property sheet and select control source. This is done but the field values are not listed in the control source.

I would be grateful if anyone can explain what is happening here.

Note, however, all the information is generated correctly.
 
Look at the sql code created in the Open event of the form.

As it is a crosstab, it is using the values in the Quarter field.
 
Northwind uses many custom Classes.
 
There are several Northwind databases , suggest you provide more details or post a copy of what you are working with.
 

Users who are viewing this thread

Back
Top Bottom