Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Need syntax help

Author  Topic 

43rdworld
Starting Member

4 Posts

Posted - 2001-10-25 : 18:03:54
I've got a script that works fine in access but when I move it over to ASP, it won't work. I'm stumped and the local ASP guru is stumped as well. The simple form of the script is:

SELECT [Projects].[ProjectID], [ProjectServices].[ProjectID], [ProjectServices].[ServicesID], [Projects].[ProjectName]
FROM Projects INNER JOIN ProjectServices ON [Projects].[ProjectID]=[ProjectServices].[ProjectID]
WHERE ((([ProjectServices].[ServicesID])=64))
ORDER BY [ProjectServices].[DisplaySeq];

I'd sure appreciate any help on this one.

Thanks.

bob

   

- Advertisement -