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

Query totals disagree with Filter totals

P: n/a
I have a database of accepted and not accepted reports. If a report is accepted...there is a check box that is marked to show acceptance.

When I run a query of "accepted reports" I get a number of 503...........however when I just run a filter by selection on the entire database for "accepted reports"....I get a number of 498..........

To what could I owe the difference of 5 between the two......it's such a small number it's driving me crazy........and I don't see how these two could differ being they are looking for the same data?

The database contains a total of 1,024 records

If anybody could give me some suggestions as to what might be happening I would greatly appreciate it!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
It might help if you can post the query SQL and the filter criteria.

On Fri, 21 Jan 2005 18:36:07 GMT, "Eli via AccessMonster.com"
<fo***@AccessMonster.com> wrote:
I have a database of accepted and not accepted reports. If a report is accepted...there is a check box that is marked to show acceptance.

When I run a query of "accepted reports" I get a number of 503...........however when I just run a filter by selection on the entire database for "accepted reports"....I get a number of 498..........

To what could I owe the difference of 5 between the two......it's such a small number it's driving me crazy........and I don't see how these two could differ being they are looking for the same data?

The database contains a total of 1,024 records

If anybody could give me some suggestions as to what might be happening I would greatly appreciate it!


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.