If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How stop duplicate fields when creating a Report in Access?
no metter what method I use to create the report - it throws double fields
into the report. You manually delete one of each and proceed and it continues to add double fields. We did not have this issue in 2003 version. WHat is the problem and how do we fix it? |
#2
|
|||
|
|||
How stop duplicate fields when creating a Report in Access?
Are you talking about the record source (a query) for the report listing
fields twice? If so, check the underlying query and see if it has an asterisk (return all fields) in SELECT clause of the query. It is a property of queries in design view (Output all fields). Set this to No to eliminate the fields showing up twice. In 2007 you can probably stop this from being the default. Click the Office Button Click Access Options Click Object Designers Uncheck Output All Fields John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County dj wrote: no metter what method I use to create the report - it throws double fields into the report. You manually delete one of each and proceed and it continues to add double fields. We did not have this issue in 2003 version. WHat is the problem and how do we fix it? |
#3
|
|||
|
|||
How stop duplicate fields when creating a Report in Access?
To add to John's information I have had queries that in the design view did
not show the asterisk but if you looked at the SQL it was there. -- Build a little, test a little. "John Spencer" wrote: Are you talking about the record source (a query) for the report listing fields twice? If so, check the underlying query and see if it has an asterisk (return all fields) in SELECT clause of the query. It is a property of queries in design view (Output all fields). Set this to No to eliminate the fields showing up twice. In 2007 you can probably stop this from being the default. Click the Office Button Click Access Options Click Object Designers Uncheck Output All Fields John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County dj wrote: no metter what method I use to create the report - it throws double fields into the report. You manually delete one of each and proceed and it continues to add double fields. We did not have this issue in 2003 version. WHat is the problem and how do we fix it? . |
Thread Tools | |
Display Modes | |
|
|