passing parameters for weekly and monthly report

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hi Friends,
I want to know how to automate Date Parameters for Weekly Report in my
query. There is a report in which i have two different dates
parameters. The report based on this query is divided into two groups
which is based on a field called TEST_STAT
Completed
In Que
For Completed i want to pass the parameter automatically for the past 7
days meaning previous week.
For In Que i want to automatically pass the parameter date starting
from 14 days from today and 30 days onwards. Meaning i want to cover
the last 14 days and the next 30 days.

I want to automate this function in my query. can anyone help me please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Issue 2
Month, DATE, Week 7
Creating an update query that uses multiple parameters 2
Aging report 3
Repeating Query Parameter in Report 2
Extract data from previous week, previous two weeks, etc. 2
Parameter Query Won't Run 0
Parameter Query help - Not passing parameter? 3

Back
Top