Field name = Cash Tble name=TotalBrokercash BGLM&Broker

[GOS]

Hello I am in a query in Acces and the Field name is called GoldmanCash
There is a table called TOTAL BROKER CASH NOT0 GOLD of where Goldman Cash's
information appears. I am having some problems with reports and the below
keeps happening.
When I view the query in design view , everything appears to be ok. When I
view it in report view the Field becomes TOTAL BROKER CASH NOT0 GOLD.Goldman
Cash

Can anyone advise what I am doing incorrectly.
Many thanks

Grace

 

[geebee]

hi,

Sounds like the name of the table is just too long. I would suggest the
practive of naming your tables no more than 10 charcters in length, and
having no spaces in the name.

Is the query returning wrong results?

Hope this helps.
geebee

 

[John Vinson]

Hello I am in a query in Acces and the Field name is called GoldmanCash
There is a table called TOTAL BROKER CASH NOT0 GOLD of where Goldman Cash's
information appears. I am having some problems with reports and the below
keeps happening.
When I view the query in design view , everything appears to be ok. When I
view it in report view the Field becomes TOTAL BROKER CASH NOT0 GOLD.Goldman
Cash

Can anyone advise what I am doing incorrectly.

We might be able to do so if we could tell what you were doing!

Please open the Query in SQL view and post the SQL text here. It seems
you may have some misplaced quotes or something, causing the fieldname
to be displayed rather than the field's value.

John W. Vinson[MVP]