Hi,
I have made a samll database using MSaccess 2000 that prints stickers. User enters info on a form and pushes the print button and preview report of that record is inisiated directly to the printer. Now I want to print a text when the "type" field Contains letter "T" and the date of expiration field has a date between one year and 10 years from today's date if it is true it will print the text if not it will not print that text.
However I don't want that text to be saved for each record becuase it will make my database big. Any suggestions.
Thank you
Rajput
[This message has been edited by rajput (edited 04-11-2001).]
I have made a samll database using MSaccess 2000 that prints stickers. User enters info on a form and pushes the print button and preview report of that record is inisiated directly to the printer. Now I want to print a text when the "type" field Contains letter "T" and the date of expiration field has a date between one year and 10 years from today's date if it is true it will print the text if not it will not print that text.
However I don't want that text to be saved for each record becuase it will make my database big. Any suggestions.
Thank you
Rajput
[This message has been edited by rajput (edited 04-11-2001).]