ghost prompt

[GM]

I initially created a query straight from a table. Then a report based off
that query. When running the report I realized I wanted to concatenate the
First and Last name.

I concatenated them in the query and deleted the First Name field(text box)
in the report and pointed the Last Name (text box) to the new concatenated
field.

I have only one prompt in the query but not on the name field. However,
when I run the report it properly prompts for the other field, but ALSO
prompts for the Last Name field.... Why???? I have completely deleted the
Last Name field and recreated a fresh one pointing to the concatenated new
Name field and it still prompts for the Last Name.

There isn't any prompt in the name field of the query and I cannot find any
'left over' field in the report for the Last Name.

When running the query, it does not prompt for the Last Name field.

In an effort to get around this, I then created a Make table from the query
and then created a new query based off the new table (that only has one field
for the full name) I pointed my query to this new table and then ran my
report and it still prompts for the Last Name field.

I am at a loss...... Please help.... Thanks

GM

 

[Jerry Whittle]

Check out your Sorting and Grouping options on the Report. If you set them
before removing the fields, it could still be looking to sort on them.

 

[GM]

I don't know what I would do without you knowledgleable people... that was it
and when removed ... it WORKED!

Thank you so much!!!!!

GM