How to create a report in Access that would use a date range

  • Thread starter Thread starter Psweigert Habitat for Humanity
  • Start date Start date
P

Psweigert Habitat for Humanity

I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
 
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
news:[email protected]...
 
.... and then base the report on that query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
news:[email protected]...
 
Thanks for the info, would I use the query wizzard for that? I am a new user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now
that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
Click to expand...
Click to expand...
 
Thanks for the info, would I use the query wizzard for that? I am a new user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now
that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
Click to expand...
Click to expand...
 
Thanks for the info, would I use the query wizzard for that? I am a new user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now
that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
Click to expand...
Click to expand...
 
Thanks for the info, would I use the query wizzard for that? I am a new user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now
that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
Click to expand...
Click to expand...
 
Thanks for the info, would I use the query wizzard for that? I am a new user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit. I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a seprate
report that shows what pickups we have for the week. I have a report now
that
listes everything sorted by date. I would like to be able to just get that
days information.
Thanks
Click to expand...
Click to expand...
 
The query wizard works well to provide an "outline", but you may need to
open the resulting query in design view to customize it.

(I say "may" because I just build them from scratch, and don't use the
wizard much...)

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity"
Thanks for the info, would I use the query wizzard for that? I am a new
user.

Jeff Boyce said:
One way to do this would be to use a query that points to the form to get
its selection criteria, using something like:

Forms!YourFormName!YourControlName

under the date/time field (?[PickupDate]?).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Psweigert Habitat for Humanity" <Psweigert Habitat for
(e-mail address removed)> wrote in message
I have a basic form set up that I input donations to our non for profit.
I
have a feild for a "Pickup Date". I want to create a report that would
include only the donations to be picked up that day, and maybe a
seprate
report that shows what pickups we have for the week. I have a report
now
that
listes everything sorted by date. I would like to be able to just get
that
days information.
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top