Query totals disagree with Filter totals

Eli via AccessMonster.com

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

Subscribe Post Reply

1311

Steve Jorgensen

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

Similar topics

Make Products/Orders Query Updateable.

by: Steve | last post by:

I have a products table where the PK is ProductID. Also have the standard Orders table and OrderDetails table. I created a query that joins the Orders table and OrderDetails table. The query...

Microsoft Access / VBA

group by query help

by: John Segars | last post by:

I have to identify students who have attended more than one school within a school district in the same academic year between certain dates. I have a table with stuID, enterdate, leavedate and want...

Microsoft Access / VBA

Calculate with Dates in a query with a one to many relation between tables

by: Guido | last post by:

How to cope with query output which provides all possible values based on a one to many relationship between two tables. I'm only interested in one answer per primary key in the 'one' table. I've...

Microsoft Access / VBA

Tricky query

by: Pea | last post by:

I'm working with a system usage database. I want to filter out repetitive logins. The query I have retrieves data like this: USER_DATE USER_TIME1 USER_USERID USER_ACCOUNT...

Microsoft Access / VBA

How to Energize a Dreadfully Slow Query

by: Rolan | last post by:

There must be a way to enhance the performance of a query, or find a plausible workaround, but I seem to be hitting a wall. I have tried a few tweaks, however, there has been no improvement. ...

Microsoft Access / VBA

Getting Totals From Two Different Tables In A Query

by: New Guy | last post by:

I'm trying to work with a system that somebody else built and I am confounded by the following problem: There is a table of payments and a table of charges. Each client has charges and payments...

Microsoft Access / VBA

Report / Query Problem

by: z.ghulam | last post by:

I am designing an order database at work and am having problems creating a specific report I'm after. Basically, each order has an 'order type' and what I would like is a report which lists the...

Microsoft Access / VBA

Running Totals Query Access97

by: JJM0926 | last post by:

I'm trying to create a running totals query in access 97. I have followed the directions on how to do it from Microsofts website article id 138911. I took their code they had and replaced it with...

Microsoft Access / VBA

Trouble with a multi level query

by: lostdawg | last post by:

Hi, I am having trouble with the following query. I need to sort from a list of contacts the last date each was contacted. This is to be represented in days so for instance: 0-42 days...

Microsoft Access / VBA

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General