BrokenBiker
ManicMechanic
- Local time
- Today, 15:45
- Joined
- Mar 22, 2006
- Messages
- 128
There are two queries in the database that are used to count and calculate percentages. One (Percentage Query) draws its dates from inputs to a form:
The other query is basic. All it does is show fields from several different tables. This query is used in a pivot table. There is no criteria in building this query.
Both queries use data from the Main Table. For some reason, they end up w/ a different number for total records. When you open the pivot table and select all of January, for example, it shows 820. When you open the percentage query w/ the same dates, it shows 815.
I'm really at a loss for this. I know that dates in a query can be a little tricky because of the time stamp that Access assigns to date fields, but it appears to be pulling data properly based on the dates selected.
The percentage query is "grouped" and has some expressions built into it, but even w/ grouping it should still total everything the same.
Any inputs would be appreciated.
Code:
>=CDate([Forms]![Request Percent Report Form]![Start Date]) And <DateAdd("d",1,CDate([Forms]![Request Percent Report Form]![End Date]))The other query is basic. All it does is show fields from several different tables. This query is used in a pivot table. There is no criteria in building this query.
Both queries use data from the Main Table. For some reason, they end up w/ a different number for total records. When you open the pivot table and select all of January, for example, it shows 820. When you open the percentage query w/ the same dates, it shows 815.
I'm really at a loss for this. I know that dates in a query can be a little tricky because of the time stamp that Access assigns to date fields, but it appears to be pulling data properly based on the dates selected.
The percentage query is "grouped" and has some expressions built into it, but even w/ grouping it should still total everything the same.
Any inputs would be appreciated.
