Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Running a simple query in microsoft.public.access.adp.sqlserver
Started 1 month, 2 weeks ago by Lucinda
Hi, I am very new to Access ADP and SQL. In other words I am in over my head. I am trying to write a query to sum Vacation Hours As Total Vacation Hours. I am receiving Incorrect Syntax near the keyword 'AS'. This worked in regular MDB Access so any help or advice would be greatly appreciated....
Site: Discussions in microsoft.public.access.adp.sqlserver  Discussions in microsoft.public.access.adp.sqlserver - site profile
Forum: microsoft.public.access.adp.sqlserver  microsoft.public.access.adp.sqlserver - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Bob McClellan replied 1 month, 2 weeks ago
You did not post your DML. the sql should be the same though... However, from what you've wrote... try Sum([Vacation Hours]) as 'Total Vacation Hours' hth, bob "Lucinda" <Lucinda@discussions.microsoft.com> wrote in message news:D2D2CE97-5E50-40A6-AAF6-0D882BDB1D53@microso ft.com... > Hi, > > I am very new ...
Size: 1,124 bytes
Customize:  Customize "<b>Reply 1</b>: Running a simple query in microsoft.public.access.adp.sqlserver :: microsoft.public.access.adp.sqlserver :: Discussions in microsoft.public.access.adp.sqlserv..."

Lucinda replied 1 month, 2 weeks ago
thank you. I found that if I removed the commas, it worked like a charm. SELECT EMPLID, NAME, SUM([Vacation Hours Used 1] + [Vacation Hours Used 2] + [Vacation Hours Used 3] + [Vacation Hours Used 4] + [Vacation Hours Used 5] + [Vacation Hours Used 6] + [Vacation Hours Used 7] + [Vacation Hours Used 8] + [Vacation Hours Used 9] + [...
Size: 1,845 bytes
Customize:  Customize "<b>Reply 2</b>: Running a simple query in microsoft.public.access.adp.sqlserver :: microsoft.public.access.adp.sqlserver :: Discussions in microsoft.public.access.adp.sqlserv..."

 

Top contributing authors

Name
Posts
Lucinda
2
user's latest post:
Running a simple query in...
Published (2009-11-13 13:39:00)
&nbsp; thank you. I found that if I removed the commas, it worked like a charm. SELECT EMPLID, NAME, SUM([Vacation Hours Used 1] + [Vacation Hours Used 2] + [Vacation Hours Used 3] + [Vacation Hours Used 4] + [Vacation Hours Used 5] + [Vacation Hours Used 6] + [Vacation Hours Used 7] + [Vacation Hours Used 8] + [Vacation Hours Used 9] + [Vacation Hours Used 10]) AS Total FROM LADOLFO.Combination GROUP BY EMPLID, NAME &quot;Bob...
Bob McClellan
1
user's latest post:
Running a simple query in...
Published (2009-11-13 12:20:00)
&nbsp; You did not post your DML. the sql should be the same though... However, from what you've wrote... try Sum([Vacation Hours]) as 'Total Vacation Hours' hth, bob &quot;Lucinda&quot; &lt;Lucinda@discussions.microsoft.com&gt; wrote in message news:D2D2CE97-5E50-40A6-AAF6-0D882BDB1D53@microsoft.com... &gt; Hi, &gt; &gt; I am very new to Access ADP and SQL. In other words I am in over my head....

Related threads on "Discussions in microsoft.public.access.adp.sqlserver":

ADP/2003 sends wrong query to SQL server in...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile ADP/2003 sends wrong query to SQL server in microsoft.public.access.adp.sqlserver
ADP/2003 sends wrong query to SQL server in microsoft.public.access.adp.sqlserver
Curious, why adp query interface does not support update,...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Curious, why adp query interface does not support update, action, delete queries like mdb? in microsoft.public.access.adp.sqlserver
Curious, why adp query interface does not support update, action, delete queries like mdb? in microsoft.public.access.adp.sqlserver
ADP Update Query does NOT update ! in...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile ADP Update Query does NOT update ! in microsoft.public.access.adp.sqlserver
ADP Update Query does NOT update ! in microsoft.public.access.adp.sqlserver
MS ACCESS query returns empty recordset from odbc linked...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile MS ACCESS query returns empty recordset from odbc linked sql server tables in microsoft.public.access.adp.sqlserver
MS ACCESS query returns empty recordset from odbc linked sql server tables in microsoft.public.access.adp.sqlserver
Parameter query? in microsoft.public.access.adp.sqlserver  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Parameter query? in microsoft.public.access.adp.sqlserver
Parameter query? in microsoft.public.access.adp.sqlserver
Access 3122 Error in Update query in...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Access 3122 Error in Update query in microsoft.public.access.adp.sqlserver
Access 3122 Error in Update query in microsoft.public.access.adp.sqlserver
Parameter query as row source to a combo box in...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Parameter query as row source to a combo box in microsoft.public.access.adp.sqlserver
Parameter query as row source to a combo box in microsoft.public.access.adp.sqlserver
SQL update query not working in...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile SQL update query not working in microsoft.public.access.adp.sqlserver
SQL update query not working in microsoft.public.access.adp.sqlserver
Performing a Query against Access 2003 from SQL Server 64...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Performing a Query against Access 2003 from SQL Server 64 bit? in microsoft.public.access.adp.sqlserver
Performing a Query against Access 2003 from SQL Server 64 bit? in microsoft.public.access.adp.sqlserver
Cannot maintain reocrd position after re-query - help!...  Discussions in microsoft.public.access.adp.sqlserver - site profile microsoft.public.access.adp.sqlserver - forum profile Cannot maintain reocrd position after re-query - help! in microsoft.public.access.adp.sqlserver
Cannot maintain reocrd position after re-query - help! in microsoft.public.access.adp.sqlserver

Related threads on other sites:

A brand new query tool is out on beta, and we need...  Discussions in microsoft.public.sqlserver.tools - site profile microsoft.public.sqlserver.tools - forum profile A brand new query tool is out on beta, and we need feedback We at Nob Hill Software are working on a new query tool: in microsoft.public.sqlserver.tools
A brand new query tool is out on beta, and we need feedback We at Nob Hill Software are working on a new query tool: in microsoft.public.sqlserver.tools
Query in microsoft.public.sqlserver.fulltext  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Query in microsoft.public.sqlserver.fulltext
Query in microsoft.public.sqlserver.fulltext
Query using lots of like % in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Query using lots of like % in microsoft.public.sqlserver.fulltext
Query using lots of like % in microsoft.public.sqlserver.fulltext
Help needed with SELECT query in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Help needed with SELECT query in microsoft.public.sqlserver.fulltext
Help needed with SELECT query in microsoft.public.sqlserver.fulltext
SQL Server 2008 iFTS Query Plan Question/Problem in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile SQL Server 2008 iFTS Query Plan Question/Problem in microsoft.public.sqlserver.fulltext
SQL Server 2008 iFTS Query Plan Question/Problem in microsoft.public.sqlserver.fulltext
Dynamic CONTAINSTABLE query issue in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Dynamic CONTAINSTABLE query issue in microsoft.public.sqlserver.fulltext
Dynamic CONTAINSTABLE query issue in microsoft.public.sqlserver.fulltext
Full-text Query very slow. in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Full-text Query very slow. in microsoft.public.sqlserver.fulltext
Full-text Query very slow. in microsoft.public.sqlserver.fulltext
Full Text Query - 1st Execution Time in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile Full Text Query - 1st Execution Time in microsoft.public.sqlserver.fulltext
Full Text Query - 1st Execution Time in microsoft.public.sqlserver.fulltext
How to force query to use a full-text index first? in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile How to force query to use a full-text index first? in microsoft.public.sqlserver.fulltext
How to force query to use a full-text index first? in microsoft.public.sqlserver.fulltext
FTS query causing performance issues in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.fulltext - site profile microsoft.public.sqlserver.fulltext - forum profile FTS query causing performance issues in microsoft.public.sqlserver.fulltext
FTS query causing performance issues in microsoft.public.sqlserver.fulltext
Thread profile page for "Running a simple query in microsoft.public.access.adp.sqlserver" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Running a simple query in microsoft.public.access.adp.sqlserver", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity