A quick question.
I have just deleted all records from a table.
The address ID field has a primary key attached to it.
How do I set the autonumber back to 0
Many Thanks
I am looking for a criteria expression using access that lists all peoples names (from my surname field) if they have a upcoming birthday during next month (from my birthdate field).The table containing the surname field and birthdate field is called client information.
Any help would be greatly...
Thanks for your reply Ken.
Is this correct.
WHERE ((((([Client Infomation]![Birthdate]=Month (DateAdd("m",1,Date())) & ";"
Where do I enter the Surname field in this expression.
I keep getting invalid syntax.
I am looking for a criteria expression using access that lists all peoples names (from my surname field) if they have a upcoming birthday during next month (from my birthdate field).The table containing the surname field and birthdate field is called client information.
Any help would be greatly...
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.