Date filter

[Linda Adams]

I have a report which is monitoring the stock (and hence the current value)
of some products which I need to print out according to the financial year.
The filters are control by a date dialog box where the user inputs starting
and ending dates. There is also a field on the report which calculates the
total stock left. The product started with 100 and has to calculate how
much is left altogether. This last calculation must not be constrained by
the date filter as I need to have the total stock to hand.

At the moment when I enter the date in a date dialog box, it not only gives
me the sales for (say) the current financial year but also calculates the
total stock according to the filter - i.e. also accoridn to the current
financial year (thus is is showuing 99 shirts when I now there are actuually
53) when I actually need to calculate some of the stock completely
disregaridng any dates inposed by the filter..

Is there any way I can tell a report to calculate sales just between two
specified dates but to make other calculations (i.e. current stock and
current value of stock)disregarding the date filters. In other words can I
take the filter off for some fields and leave it on for others.

Linda Adams

 

[Rebecca Riordan]

What about creating a query that performs the calculation (sans filter) and
the use a DLookup to plug the value into the report?

HTH

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress

 

[Linda Adams]

Many thanks, Rebecca. I actually created a separate query and then fed that
back into the original query. It works.