Find Specific Data

B

Bronson

Helli i have a table that i need to query to find out how the type of payment
was paid.

I have figured out how to query the dates but not the type of payment.

Two types of payments are "SRD" or "EFT"

SELECT DISTINCTROW Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) AS
[SumOfTYPE INITIAL PAYMENT (EFT/SRD)], Count([Packet Log].[TYPE INITIAL
PAYMENT (EFT/SRD)]) AS [CountOfTYPE INITIAL PAYMENT (EFT/SRD)]
FROM [Packet Log]
HAVING (((Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)])) Is Not Null)
AND ((Count([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)])) Is Not Null) AND
(([Packet Log].DOS) Between [Enter START Date] And [Enter END Date]));
 
O

Ofer

Try

SELECT DISTINCTROW Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) AS
[SumOfTYPE INITIAL PAYMENT (EFT/SRD)], Count([Packet Log].[TYPE INITIAL
PAYMENT (EFT/SRD)]) AS [CountOfTYPE INITIAL PAYMENT (EFT/SRD)]
FROM [Packet Log]
HAVING Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) Is Not Null
AND Count([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) Is Not Null AND
[Packet Log].DOS Between [Enter START Date] And [Enter END Date]
And [Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)] = [Please select payment
type]
 
B

Bronson

Says expression incomplete.

Prompts me for type payment then both dates then again for type payment

Ofer said:
Try

SELECT DISTINCTROW Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) AS
[SumOfTYPE INITIAL PAYMENT (EFT/SRD)], Count([Packet Log].[TYPE INITIAL
PAYMENT (EFT/SRD)]) AS [CountOfTYPE INITIAL PAYMENT (EFT/SRD)]
FROM [Packet Log]
HAVING Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) Is Not Null
AND Count([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) Is Not Null AND
[Packet Log].DOS Between [Enter START Date] And [Enter END Date]
And [Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)] = [Please select payment
type]



--
\\// Live Long and Prosper \\//
BS"D


Bronson said:
Helli i have a table that i need to query to find out how the type of payment
was paid.

I have figured out how to query the dates but not the type of payment.

Two types of payments are "SRD" or "EFT"

SELECT DISTINCTROW Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)]) AS
[SumOfTYPE INITIAL PAYMENT (EFT/SRD)], Count([Packet Log].[TYPE INITIAL
PAYMENT (EFT/SRD)]) AS [CountOfTYPE INITIAL PAYMENT (EFT/SRD)]
FROM [Packet Log]
HAVING (((Sum([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)])) Is Not Null)
AND ((Count([Packet Log].[TYPE INITIAL PAYMENT (EFT/SRD)])) Is Not Null) AND
(([Packet Log].DOS) Between [Enter START Date] And [Enter END Date]));
Click to expand...
Click to expand...
 
Top