query access database..
Posted on 2006-07-04
I am pretty new to access database and my database got one table called salesinfo..
I need to query this table and i had hard time in doing so.
In sql server we had query analyser and enterprise manager so we can select table and can write query so it will display the result of the query in a grid..
In access i have seen only 2 options 1)Create query in Design view
2)Create query by using wizard..
Secondly one of my table field is PrintDate
Since my user workstation dateformat can vary like DD-MM-YYYY , MM-DD-YYYY.
I need to fetch all the 2006 records, so query need to omit for 09/11/ -- need check yyyy is 2006 or not if yes display
the result in a grid ..
How should i write a query and what is the query for the above mentioned scenario..