How do I Create a Access Mailing Label Report by Date Range?

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

Guest

I am trying to create mailing labels with MS Access by entering in a birthday
date range. I currently only have a table with the following FIELD NAMES:

First (Text)
Last (Text)
Address (Text)
CityState (Text)
Zip (Number)
Birthday (Date/Time)

Please help. I am VERY new to Access.
 
Create a query with the fields you have. Put the following expression in the
criteria of the Birthday field:
Between [Enter Starting Date Of Date Range] And [Enter Ending Date Of Date
Range]. Use the Label Wizard in Reports to create your label report. Follow
the directions there. Base your label report on the query.
 
If you are looking for a report where you want birthdates regardless of the
year of birth, you would need to convert the Birthday field using something
like:
Format([Birthday],"mm/dd")

--
Duane Hookom
MS Access MVP


PC Datasheet said:
Create a query with the fields you have. Put the following expression in
the criteria of the Birthday field:
Between [Enter Starting Date Of Date Range] And [Enter Ending Date Of Date
Range]. Use the Label Wizard in Reports to create your label report.
Follow the directions there. Base your label report on the query.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Serts said:
I am trying to create mailing labels with MS Access by entering in a
birthday
date range. I currently only have a table with the following FIELD
NAMES:

First (Text)
Last (Text)
Address (Text)
CityState (Text)
Zip (Number)
Birthday (Date/Time)

Please help. I am VERY new to Access.
Click to expand...
Click to expand...
 
Back
Top