var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Question about queries
Im creating a database and im trying to create a query so i can create a mail merge, i wnat the query to bring up a list of any students whose qualification ends within 30 days,
if anyones got any questions which i havent asked then just reply with your question and ill get back to you
Try a criteria of this on the qualification date field:
<(Date() + 30)
< DateAdd("d", 30, Date())
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
Ok thanks for replying, i should have mentioned that each of the students qualification ended last year between 16/03/07 and 21/05/07, would it be easier to just change the date for when the qualification ends, or is that too much trouble, ive got a backup so might give it a try