 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2006Field name = Cash Tble name=TotalBrokercash BGLM&Broker
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 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 > 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 [quoted text clipped - 9 lines] > Grace > >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 [quoted text clipped - 5 lines] > >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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.