Extra digit in Table

[Guest]

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?

 

[John W. Vinson]

On Fri, 31 Aug 2007 09:28:03 -0700, Dana Townley <Dana

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]

 

[Guest]

Is there anyway I can e-mail you instead. I would not like to put this
information in a public form.

 

[John W. Vinson]

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]