Report/query help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to design a report that will pull
data from scheduled trips.
What I have:
controls: "start date" "end date"
check boxes" "sun" "mon" "tue" "wed" "thu" "fri" "sat"
I'd like to:
1. run a report just for today
2. run a report that includes today + 6 days out
Any help will be greatly appreciated
Running Access 2000
Tom
 
Not really sure what your "mon", "tue", "wed", fields are for so a bit more
info would be helpful

To get the report/query to run from [StartDate] and next 6 days just set the
critiera as

Between [StartDate] And DateAdd("d",6,[StartDate])

And for today use

Date()
 
Wayne,
Thanks for the help. I have on my form
"check boxes" for each day of the week.
These scheduled runs are for a delivery
service.
EX: John Doe has deliveries scheduled
between [StartDate] 6/9/2006
and [EndDate] 7/9/2006
They are to occur on
"mon" "wed" "fri" (these boxes are checked)

If this is my only delivery then
My 2 reports that I want:
1. today plus 6 days should
only print Monday the 12th of June
and Wednesday the 14th of June
2. Nothing for today
I'm new to this and the queries
I'm extremely new to.
Thanks for you help.
Tom



Wayne-I-M said:
Not really sure what your "mon", "tue", "wed", fields are for so a bit more
info would be helpful

To get the report/query to run from [StartDate] and next 6 days just set the
critiera as

Between [StartDate] And DateAdd("d",6,[StartDate])

And for today use

Date()


--
Wayne
Manchester, England.



Tom said:
I'm trying to design a report that will pull
data from scheduled trips.
What I have:
controls: "start date" "end date"
check boxes" "sun" "mon" "tue" "wed" "thu" "fri" "sat"
I'd like to:
1. run a report just for today
2. run a report that includes today + 6 days out
Any help will be greatly appreciated
Running Access 2000
Tom
Click to expand...
Click to expand...
 
It would appear that you're using dd/mm/yyyy as your Short Date format. Even
if you've set it correctly through Regional Settings, Access is going to
interpret 6/9/2006 as 9 June, 2006, and 7/9/2006 as 9 July, 2006 in SQL
statements.

You might want to read Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html
or what I have in my September 2003 Access Answers column for Pinnacle
Publication's "Smart Access" newsletter. (The column and accompanying
database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Tom said:
Wayne,
Thanks for the help. I have on my form
"check boxes" for each day of the week.
These scheduled runs are for a delivery
service.
EX: John Doe has deliveries scheduled
between [StartDate] 6/9/2006
and [EndDate] 7/9/2006
They are to occur on
"mon" "wed" "fri" (these boxes are checked)

If this is my only delivery then
My 2 reports that I want:
1. today plus 6 days should
only print Monday the 12th of June
and Wednesday the 14th of June
2. Nothing for today
I'm new to this and the queries
I'm extremely new to.
Thanks for you help.
Tom



Wayne-I-M said:
Not really sure what your "mon", "tue", "wed", fields are for so a bit
more
info would be helpful

To get the report/query to run from [StartDate] and next 6 days just set
the
critiera as

Between [StartDate] And DateAdd("d",6,[StartDate])

And for today use

Date()


--
Wayne
Manchester, England.



Tom said:
I'm trying to design a report that will pull
data from scheduled trips.
What I have:
controls: "start date" "end date"
check boxes" "sun" "mon" "tue" "wed" "thu" "fri" "sat"
I'd like to:
1. run a report just for today
2. run a report that includes today + 6 days out
Any help will be greatly appreciated
Running Access 2000
Tom
Click to expand...
Click to expand...
Click to expand...
 
Back
Top