Find the reference of a bounded field (1 Viewer)

grenee

Registered User.
Local time
Today, 08:32
Joined
Mar 5, 2012
Messages
210
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.
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:32
Joined
Sep 21, 2011
Messages
14,270
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:32
Joined
May 7, 2009
Messages
19,237
Northwind uses many custom Classes.
 

jdraw

Super Moderator
Staff member
Local time
Today, 11:32
Joined
Jan 23, 2006
Messages
15,379
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

Top Bottom