DateDiff in query

[augie0216]

I have a table with 5 Fields PatientID,FirstName,LastName,BalanceDue and,DueDate.I want to create a query that shows 4 catagories under 30,over 30,over 60,over 90 of balances due . I've tried using this as a sixth field as a test
field name under 30: DateDiff("d", [DueDate] ,Now()).Criteria >0 and<30. But when the parameter dialog pops up and I enter 30 and click ok the field headings show up but no data is present. I would like it to show all the patient info for all duedates 30 days or less. Any ideas on what I'm doing wrong, I'm new at access so I'm probaly doing everything wrong.

[PEB]

Hi,

What is the name of your parameter? Can you give us your SQL? What type are your dates? As text or Date/Time?

[MMcCarthy]

You have to tell the query what to put in the value of the field if the criteria is true.

Under_30: IIf((DateDiff("d", [DueDate] ,Now()) > 0) And (DateDiff("d", [DueDate] ,Now()) < 30), <What do you want to appear in the field e.g. "Yes"?>, "")

I have a table with 5 Fields PatientID,FirstName,LastName,BalanceDue and,DueDate.I want to create a query that shows 4 catagories under 30,over 30,over 60,over 90 of balances due . I've tried using this as a sixth field as a test
field name under 30: DateDiff("d", [DueDate] ,Now()).Criteria >0 and<30. But when the parameter dialog pops up and I enter 30 and click ok the field headings show up but no data is present. I would like it to show all the patient info for all duedates 30 days or less. Any ideas on what I'm doing wrong, I'm new at access so I'm probaly doing everything wrong.