Parameter Query Problem

[Fiona]

Hi,
I'm new to the forum and need help in working out why the following does not work.

I have created a report with a subreport which are run from two queries respectively. My problem is this.

When I use the "Between [Start] and [End]" criteria in the subreport query it creates a loop that I can't get out of when i try and open the main report, however if I use "< Now() - 30" it works fine.

I am trying to create a report that pulls all clients from one table (main report) and all their treatements from another table (subreport) for a particular month ie Between 01/01/06 and 31/01/06.

Can you help PLEASE???
Fiona

[zzqxxq]

As I was reading this in the US, the thought struck me as to how you denoted the dates you gave as examples you typed 01/01/06 to 31/01/06 - not US format, which would be 01/01/06 to 01/31/06 - check your windows regional setting to make sure they match what you are entering. If windows itself is set for US format mm/dd/yy and you enter dd/mm/yy that might be the problem. Either enter dates in US format or change the windows regional settings. If that dosent work write back