Hi Colorado,
There should be additional "empty" fields available in the QBE grid to add a new field. You can
have up to 255 fields in a query (although you'll never want to even come close to this--a more
realistic upper limit, and the default flagged by a tool called Total Access Analyzer, is 32
fields in a query). If you use the horizontal scroll bar at the bottom of the query builder
window, you should see additional empty fields available. It may be helpful to maximize this
window, in order to see the scroll bar.
You can double-click on the new field to add it, drag it from the top window and drop it onto the
bottom window to add it, or select the field from the "Field:" dropdown in the lower window,
using an empty field. It really doesn't need to be added in the last position. You can add the
new field at the beginning, or in-between two existing fields, by dropping it at the appropriate
location.
Tom
____________________________________________
Tom,
Thank you. You were correct. It was a SQL statement. In the bottom of the query builder window
(with the list of the fields) there was one column on
the far right left open to add another field. So I added one of the two fields there. How do I
add another column so I can add the second field?
Colorado
____________________________________________
Colorado,
It sounds to me like the recordsource for your report is a SQL statement (in other words, a query
that is self-contained within the report, instead of being saved as a querydef). Open the report
in design view. Click on View > Properties to display the properties dialog, if it is not already
displayed. Make sure that "Report" is displayed in the blue title bar of the Properties window
(if necessary, click on the small black square in the upper left corner to select the report
properties). Click on the Data tab. The first item reads "Record Source..........". Do you see
something that looks like it starts with SELECT? If so, click into the record source line. Now
click on the ellipses button (the button with the three dots). This should open the query
builder. Add the two new fields to your query. Click on the X in the upper right corner to close
the query builder. Click on OK to accept the changes.
Tom
____________________________________
I'm not sure of anything! But when I click on queries in the database view, there are no
queries, only create query using wizard and create query using design view. So from this, I
think there are no queries.
____________________________________
Are you sure that the report is based on the table? If it's based on a query, then you have to
update the query to include the new fields.
____________________________________
I added two new fields to a table in a database. I want to add these fields to an existing
report. When I look at the table, the fields are there. But the field list doesn't contain
them. I've tried what was suggested in a couple of recent threads. I can't seem to find a field
list toolbar with the refresh icon referenced in the help. So I tried hitting F9 as suggested.
Nada. There is no query. What am I doing wrong and what can I do to make these fields available
to the report?
