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

[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

 

[Jeff Boyce]

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]...

 

[Jeff Boyce]

.... 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]...

 

[Psweigert Habitat for Humanity]

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

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

 

[Psweigert Habitat for Humanity]

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

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

 

[Psweigert Habitat for Humanity]

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

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

 

[Psweigert Habitat for Humanity]

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

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

 

[Psweigert Habitat for Humanity]

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

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

 

[Jeff Boyce]

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.

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