By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,337 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Problem Formatting In Query Grid

P: n/a
I know this will be simple but it has me stuck. I've trawled the
newsgroup and can't find the answer that I need.

I have 2 fields in the query grid:
WithHaz: Nz([CountCsafes2].[CountOfCSNo],0) and
NoIssues: Nz([CountCsafesNoIssues2].[SumOfQuantity],0)

When I try to add these fields using [WithHaz]+[NoIssues] instead of
getting the sum of the 2 values, I'm getting their individual string
values joined together as one string.

How do I force them to be seen as numbers instead of strings?

Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found it! CInt

Oct 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.