If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I Create a Access Mailing Label Report by Date Range?
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. |
#2
|
|||
|
|||
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 www.pcdatasheet.com "Serts" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message nk.net... 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 www.pcdatasheet.com "Serts" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
how to create web report from access 2002? | Lanrygee | Setting Up & Running Reports | 0 | May 12th, 2005 05:24 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |