nyee84
asked on
query access database..
Hi Experts,
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..
Tottaly lost...
Secondly one of my table field is PrintDate
PrintDate
09/11/2006
11/09/2006
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..
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..
Tottaly lost...
Secondly one of my table field is PrintDate
PrintDate
09/11/2006
11/09/2006
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..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is a tutorial for u
The site may be useful for u as it contains other info as well regarding Access
http://www.functionx.com/access/Lesson16.htm
The site may be useful for u as it contains other info as well regarding Access
http://www.functionx.com/access/Lesson16.htm
ASKER
Hi Experts,
Thanks for all the comments..
Thanks for all the comments..
select * from yourtable where Year(PrintDate) = 2006