Having "Total Amount of Currency" in a table is a definite error and
having
"Boxed Coin" as a field may be an error. List what fields 2 to 9 and 12
are
and provide any explanation needed.
I changed some fields around, how does this look?
Tables:
Account Analysis Table
Fields:
1. ID Autonumber
2. Client Name (32 Clients with some sharing account numbers)
3. Service Code (rolled coin = 385 and Total Currency Amount = 390)
4. Volume (Boxed Coin * 50 and Total Currency Amount)
5. Pennies
6. Nickels
7. Dimes
8. Quarters
9. Halves
10. Month of Activity ( January - December) (Parameter in my Query)
Boxed Coin and Currency Table
Fields
1. ID Autonumber
2. Boxed Coin
3. Total Currency Amount
Queries:
Account Analysis Query
Show Tables: Account Analysis Input Table, AA Client List Table, Boxed
Coin
and Currency
Fields in Query: From Table
1. Client Name Account Analysis Input
Table
2. Client Account # AA Client List Table
3. Service Code Account Analysis Input
Table
4. Volume Account Analysis
Input
Table
5. Pennies Account Analysis
Input
Table
6. Nickels Account Analysis
Input
Table
7. Dimes Account Analysis
Input
Table
8. Quarters Account Analysis
Input
Table
9. Halves Account Analysis
Input
Table
10. Month of Activity Account Analysis Input
Table
11. Boxed Coin Boxed Coin and Currency
12. Total Currency Amount Boxed Coin and Currency
PARAMETERS [Month of Activity] Text;
SELECT [Account Analysis Input Table].[Client Name], [AA Client List
Table].
[Client Account #], [Account Analysis Input Table].[Service Code],
[Account
Analysis Input Table].Volume, [Account Analysis Input Table].Pennies,
[Account Analysis Input Table].Nickels, [Account Analysis Input
Table].Dimes,
[Account Analysis Input Table].Quarters, [Account Analysis Input Table].
Halves, [Account Analysis Input Table].[Month of Activity], [Boxed Coin
and
Currency].[Boxed Coin], [Boxed Coin and Currency].[Total Currency Amount]
FROM ([Account Analysis Input Table] LEFT JOIN [AA Client List Table] ON
[Account Analysis Input Table].[Client Name] = [AA Client List
Table].[Client
Name]) LEFT JOIN [Boxed Coin and Currency] ON [Account Analysis Input
Table].
ID = [Boxed Coin and Currency].ID
WHERE ((([Account Analysis Input Table].[Month of Activity])=[Month of
Activity]));
-Charles-