Date Range Query help

T

theman1078

I have a subfrm linked to a main form using an employee code. I
designed the report to reflect these details. I have a print preview
button on the main form which previews what I need to print. I have a
perimeter query linked to the sub report which prompts the user to
enter a date range. The problem is that 1. the date range is
requested twice
2. It
displays all the information between the date range and not just for
that employee that I need it for.

Can anbody give me some advice. I have been trying for a week now.

I think I am probably going about it the wrong way

Many regards
 
T

Tom Ellison

Dear Man:

I recommend you post here the SQL text of your query. I might be able to
fix it up.

Tom Ellison
 
T

theman1078

Thanx for the reply, Under date i have the following criteria, this
query is then used as the record source for the subreport

Between [Enter Start Date] And [Enter Finish Date]
 
T

Tom Ellison

Dear Man:

If you would please open the query in SQL View, there's much more there that
describes the entire query. That's what I'd like to see in order to help
you. In addition, I can make recommended changes to that, which you can
subsequently paste back into the SQL View and give it a try.

OK?

Tom Ellison
 
Top