weekly reports

[nabs]

I need to get weekly reports from an accounts databasefrom access 2003how do
I get dates >=and date<= I want to be able to apply this in the report header.
thanks anyone

 

[Arvin Meyer [MVP]]

Assuming your dates are supplied to a query from the form, the query
criteria would look like:

= Forms!FormName!StartDate And <= Forms!FormName!EndDate

and the report header would look like:

= "From " & Format(Forms!FormName!StartDate, "mm/dd/yyyy") & " To " &
Format(Forms!FormName!EndDate, "mm/dd/yyyy")

 

[Wayne-I-M]

Hi

You could ask users for a start date and end date by adding a parameter
prompt to the query.

Add this to the criteria row of the column containing the start and end dates
[Enter start date] [Enter end date]

Then add an unbound textbox to the header of the report with this as the
control source.
="Accounts from " & (Format([StartDate],"ddd dd mmmm yyyy")) & " to " &
(Format([EndDate],"ddd dd mmmm yyyy"))

Of course change the [StartDate] and [EndDate] to what they really are in
your application.

Hope this helps

 

[nabs]

thanks everyone Iwiil trythis out

Hi

You could ask users for a start date and end date by adding a parameter
prompt to the query.

Add this to the criteria row of the column containing the start and end dates
[Enter start date] [Enter end date]

Then add an unbound textbox to the header of the report with this as the
control source.
="Accounts from " & (Format([StartDate],"ddd dd mmmm yyyy")) & " to " &
(Format([EndDate],"ddd dd mmmm yyyy"))

Of course change the [StartDate] and [EndDate] to what they really are in
your application.

Hope this helps

--
Wayne
Manchester, England.

I need to get weekly reports from an accounts databasefrom access 2003how do
I get dates >=and date<= I want to be able to apply this in the report header.
thanks anyone

 

[Wayne-I-M]

My answer my just an alternative to the answer given by Arvin. I would
suggest that it would be better (simpler for users) to use the QBF method
that Arvin gave.

--
Wayne
Manchester, England.

thanks everyone Iwiil trythis out

Hi

You could ask users for a start date and end date by adding a parameter
prompt to the query.

Add this to the criteria row of the column containing the start and end dates
[Enter start date] [Enter end date]

Then add an unbound textbox to the header of the report with this as the
control source.
="Accounts from " & (Format([StartDate],"ddd dd mmmm yyyy")) & " to " &
(Format([EndDate],"ddd dd mmmm yyyy"))

Of course change the [StartDate] and [EndDate] to what they really are in
your application.

Hope this helps

--
Wayne
Manchester, England.

I need to get weekly reports from an accounts databasefrom access 2003how do
I get dates >=and date<= I want to be able to apply this in the report header.
thanks anyone

 

[nabs]

thanks this worked as well

My answer my just an alternative to the answer given by Arvin. I would
suggest that it would be better (simpler for users) to use the QBF method
that Arvin gave.

--
Wayne
Manchester, England.

thanks everyone Iwiil trythis out

Hi

You could ask users for a start date and end date by adding a parameter
prompt to the query.

Add this to the criteria row of the column containing the start and end dates
[Enter start date] [Enter end date]

Then add an unbound textbox to the header of the report with this as the
control source.
="Accounts from " & (Format([StartDate],"ddd dd mmmm yyyy")) & " to " &
(Format([EndDate],"ddd dd mmmm yyyy"))

Of course change the [StartDate] and [EndDate] to what they really are in
your application.

Hope this helps

--
Wayne
Manchester, England.



:

I need to get weekly reports from an accounts databasefrom access 2003how do
I get dates >=and date<= I want to be able to apply this in the report header.
thanks anyone

 

[nabs]

brilliant thanks a lot this was just the right thing