View Full Version : Query question


Alan Lander
02-20-2004, 08:38 AM

I have a table with client name, address and birthdates. Every month we send birthday cards to clients who have birthdates in the upcoming month. I have labels designed to place on the cards, and a button on the main form to print the labels. The question is the diffuclty I am having in designing a prompt for the user to type in the month of the birthdate that they want to print (there are over 7000 names in the database). I can do it in the design mode, but if I create a dialoge box to prompt for the month it does not seem to work. I am guessing that a varable saved as a character will not querry a date. I know this has been done before -and I bet it is easy. If anyone can help or point me to the right direction that would be much appreciated.

Alan Lander
02-20-2004, 08:39 AM
OOops -wrong message board. Sorry.