I have a SQL statement that I run in MS Access 2010 with a WHERE clause on the date. The date is passed into the module in the format of 31/12/2011, however I need it to be in the format of 12/31/2011.
How do I cahnge the value to 12/31/2011 prior to running the SQL ?
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…