 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / August 2007Extra digit in Table
So a query was set up to output certain data, my problem is, I have a random extra number in only one of the tables. In the field I have a column for the count, and another column that averages the count dividing it by another field on the table. It looks like ([count]=0,0,([total]/[count])) When the table comes up in the Count column there is an extra 0. so if the number is supposed to be 2 it shows 20. I have tried dividing the count by ten, taking things out and adding them back, configuring the display columns, everything that I can think of that would make sense. What am I doing wrong? >When the table comes up in the Count column there is an extra 0. so if the >number is supposed to be 2 it shows 20. I have tried dividing the count by >ten, taking things out and adding them back, configuring the display columns, >everything that I can think of that would make sense. > >What am I doing wrong? I don't know, because I don't know what you're doing. Please post the SQL view of the query. It sounds like a number is somehow being converted to text, but without seeing the context it's hard to say why. John W. Vinson [MVP] Is there anyway I can e-mail you instead. I would not like to put this information in a public form. > >When the table comes up in the Count column there is an extra 0. so if the > >number is supposed to be 2 it shows 20. I have tried dividing the count by [quoted text clipped - 10 lines] > > John W. Vinson [MVP] >Is there anyway I can e-mail you instead. I would not like to put this >information in a public form. Not asking you to post any *data*, just the SQL of the query. Are your fieldnames confidential? If so, could you just copy the SQL to Notepad, edit them to Fieldx, Fieldy, and post? I really prefer to keep EMail support limited to paying customers - I'm a self-employed consultant donating my time here and would like to keep it under control. 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
|
©2009 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.