Pass Through Query to Oracle Table

[James C.]

I am having problems writing a SQL pass-through query to an Oracle table. The
query that I am doing is straight forward, however, I know that the SQL code
is different from Access SQL.

Here is the code

(Select (Sum(Net_Booking_Count)) Bookings,
From Master_Table
Where Date = 1/1/2005)

If I remove the Sum it works. Whenever I put in the Sum and have it change
the name to Bookings it errors out.

Does anyone know what I might be doing wrong? Also does anyone know a good
site that breaks down Oracle SQL code to use for MS Access queries.

Thx

 

[Lynn Trapp]

I'm not quite sure why you are using all the extra parens and there is an
extraneous comma in your SQL, but the following should work:

Select Sum(Net_Booking_Count) Bookings
From Master_Table
Where Date = '01-JAN-2005'


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Lynn Trapp]

I know in all my Oracle SQL I would have to format the date you want as:

WHERE
DATE = to_date('DD-MON-YYYY','01-JAN-2005')

Oracle will do some implicit data conversions for proper date strings, so
this should work:

DATE = '01-JAN-2005'

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Lynn Trapp]

Doug,
Oracle SQL syntax doesn't require the AS keyword for an alias. Also, the
date strings are written inside single quotes -- '01-JAN-2005'

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html