Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Masaud
-
Thanks SMUCKERS..:)..need a little more help
I think I am using ADO. I might be wrong here. Sorry but I am not expert and I might be wrong...I am a beginner:( Following is what I get when I make a connection..(start WinSQL) DSN=MS Access Database;DBQ=C:\Documents and Settings\Masaud\Desktop\SQL quries\db1.mdb;DefaultDir=C:\Documents and...- Masaud
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Thanks SMUCKERS..:)..need a little more help
Smuckers thanks for your help... I downloaded WinSQL as you told me and it is working fine. It made it very easy to write quries. But I am stuill not able to run functions. For example: select last_name, TO_CHAR(hire_date, 'MM/YY') from employees; Error: Undefined function 'TO_CHAR' in...- Masaud
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
-
MS Access and SQL
Hi, I am starting to learn SQL. I was practicing some quries in Access, but Functions do not work there. (For example COCAT, UPPER, LOWER, etc). LIKe operator did not work either. I am wondering if this is ACCESS's limitation? If yes, can anyone suggest me some better tool where I can practice...- Masaud
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
