I have a macro in Access that runs a query then starts the mail-merge wizard. I hope this means that that it will merge the records found by the query. The problem is when i try to link this query to a word document. When i get to the part of the wizard in word where you select a data source...
I originally had:
Between date() And date()+5
but there is a big problem with this. It takes account of the year. I want it to select dates of birth that have the same month and day (not year) because birthdays happen every year, not just this year.
I need an expression that will match the...
I have a table with the usual details about customers. I want a query to check to see if there are any customer birthdays within 5 days of todays date.
I put the following code into the Date of Birth field criteria:
Between DatePart("m",Date()) And...
I have a query that checks something everytime the database is run. I only want it to show itself or alert the user somehow if it finds something.
So, How do I not show this query if it doesn't find any records?
I am an inexperienced user of Access so please reply in non technical language.
I have 2 tables. 1 table has specific details about the sale of a product (e.g. dates) and the other table has customer details.
Most of the time 1 record in the sale details table is related to 1 customer...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.