microsoft access select statement

[leonardc]

Hi, can we and how to write COMMENT from a query in a
select statement example:
(///I would like to add a comment here///)
SELECT QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME, Sum(QryCrops.RECEIPT) AS
SumOfRECEIPT, Sum([RECEIPT]*0.019) AS misc_calc_SC_factor,
[SumOfRECEIPT]+[misc_calc_SC_factor] AS TotalCrops
FROM QryCrops
GROUP BY QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME
HAVING (((QryCrops.PROVINCE_CODE)="10"))
ORDER BY QryCrops.YEAR;

thanks for your help!

 

[John Nurick]

Hi Leonard,

AFAIK Microsft Jet SQL doesn't provide for comments.

Hi, can we and how to write COMMENT from a query in a
select statement example:
(///I would like to add a comment here///)
SELECT QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME, Sum(QryCrops.RECEIPT) AS
SumOfRECEIPT, Sum([RECEIPT]*0.019) AS misc_calc_SC_factor,
[SumOfRECEIPT]+[misc_calc_SC_factor] AS TotalCrops
FROM QryCrops
GROUP BY QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME
HAVING (((QryCrops.PROVINCE_CODE)="10"))
ORDER BY QryCrops.YEAR;

thanks for your help!

 

[Douglas J. Steele]

On the other hand, Stephen Lebans does... <g>
http://www.lebans.com/addsqlcomments.htm

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Leonard,

AFAIK Microsft Jet SQL doesn't provide for comments.

Hi, can we and how to write COMMENT from a query in a
select statement example:
(///I would like to add a comment here///)
SELECT QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME, Sum(QryCrops.RECEIPT) AS
SumOfRECEIPT, Sum([RECEIPT]*0.019) AS misc_calc_SC_factor,
[SumOfRECEIPT]+[misc_calc_SC_factor] AS TotalCrops
FROM QryCrops
GROUP BY QryCrops.YEAR, QryCrops.PROVINCE_CODE,
QryCrops.PROVINCE_NAME
HAVING (((QryCrops.PROVINCE_CODE)="10"))
ORDER BY QryCrops.YEAR;

thanks for your help!