katzukikatzuki
Terminated Account
- Messages
- 97
- Reaction score
- 0
- Points
- 16
patambay
)
![Smile :) :)](/images/smilies/smile.gif)
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
na try nyo ba yan sir ? kasi kung ang expected out nyo is
january 9 - 16
between 9 - 16 ang lalabas dyan is 9 10 11 12 13 14 15 16
yan po may example ako![]()
between 9 - 16 ang lalabas dyan is 9 10 11 12 13 14 15 16
haha.. di nyo po ako gets. Okay sa na yung codes mo eh. kaso hindi po ganyan ...
ganito....
base tayo sa example na binigay mo/.
ang gusto kong output dyan ay 9 - 16
hindi yung 9 10 11 12 13 14 15 16
yan.tia
medyo naguluhan na ako dun sir..
ayaw mo ng 9 10 11 12 13 14 15 16
pero gusto mo yung 9 - 16?
9 and 16 lang ba gusto mo?
o 9 - 16?
9 - 16 di ba consist of (9 10 11 12 13 14 15 16) ?
o 9 and 16 lang gusto mo ?
tulungan mo nga ako sir mukhang nalito na ako sa tinatanong mo![]()
eto nalang , wala kang babaguhin sa output ko..
goal mo dapat mapalabas mo yung expected output ko ..
oo, tama eto lang gusto ko
"9 - 16" ayoko yung between nyan.. ganyan lang. cheers.
pinagiisipan ko pa din, medyo mahirap eh.![]()
eto ang output ng between ng 9 - 16
january 9 2007
january 10 2007
january 11 2007
january 12 2007
january 13 2007
january 14 2007
january 15 2007
january 16 2007
eto sir kung mali yung picture na naka attach di na kita matutulungan.![]()
thanks ah.. nakuha ko na haha. medyo tricky kasi to eh.
tingnan mo tong codes ko.. eto yung need ko.. yan para mag ka idea ka. thanks sir. problem solved na
SELECT DISTINCT min(a.date_survey),max(a.date_survey),a.site_id
FROM survinfo_2dir a, site b
WHERE a.site_id= b.site_id AND b.survey_type = 2 AND a.site_id = "SV01026LZ_AC"
AND datepart(yy,a.date_survey) = 2007
GROUP BY a.site_id, datepart(mm,a.date_survey)
order by a.site_id,datepart(mm,a.date_survey)
;
MAG SIR PANU PO KUMUHA NG DATA NA NAKA SAVE SA MICROSOFT ACCESS TAPOS PO AY DAPAT PO AY KUNG SAAN NYU SINAVE NA ACCOUNT DAPAT AY YUN PARIN KUNG ANUNG NAKA INPUT DOON SA FORM...TULONG PO SALAMAT PO
NEED LANG PO TALAGA SIR
SALAMAT PO SA REREPLY
MAG SIR PANU PO KUMUHA NG DATA NA NAKA SAVE SA MICROSOFT ACCESS TAPOS PO AY DAPAT PO AY KUNG SAAN NYU SINAVE NA ACCOUNT DAPAT AY YUN PARIN KUNG ANUNG NAKA INPUT DOON SA FORM...TULONG PO SALAMAT PO
NEED LANG PO TALAGA SIR
SALAMAT PO SA REREPLY
select distinct aa.site_id,aa.date_survey,aa.hour,sum(aa.cnt)as cn2 from (
SELECT ab.site_id, ab.date_survey, ab.hour, ab.cnt FROM(
SELECT a.site_id,a.date_survey,(a.hour_from + " - " + a.hour_to) AS hour, b.volume as cnt
FROM survinfo_1dir a,survraw_1dir b
WHERE a.site_id = "SV01003LZ_MC" AND a.header_no=b.header_no
AND a.date_survey = "7/12/2004"
UNION ALL
SELECT c.site_id,c.date_survey,(c.hour_from + " - " + c.hour_to) AS hour, (isnull(d.volume_inc_post,0 ) + isnull(d.volume_dec_post,0)) as cnt
FROM survinfo_2dir c,survraw_2dir d
WHERE c.site_id= "SV01003LZ_MC" AND c.header_no=d.header_no
AND c.date_survey = "7/12/2004"
)ab
GROUP BY ab.site_id,ab.date_survey, ab.hour
)aa
group by hour;
i restrive mo parang ganito kung tama pag intindi ko sa question
set rs = new adodb.recordset
rs.open "select * from table_name where id ='" & txtusername.text & "'", connection_variable, 3, 2
if not rs.eof then
txtname.text = rs!column_name
txtage.text = rs!column_name_for_age
end if
rs.close
set rs = nothing
Paano ako gagawa ng column, which is sum ng Cn2 sa sql?
here's the pix.
View attachment 789755
Note wala yang sum na Column .. pero paano ko ididisplay yan ? thanks po..
eto code ko
Code:select distinct aa.site_id,aa.date_survey,aa.hour,sum(aa.cnt)as cn2 from ( SELECT ab.site_id, ab.date_survey, ab.hour, ab.cnt FROM( SELECT a.site_id,a.date_survey,(a.hour_from + " - " + a.hour_to) AS hour, b.volume as cnt FROM survinfo_1dir a,survraw_1dir b WHERE a.site_id = "SV01003LZ_MC" AND a.header_no=b.header_no AND a.date_survey = "7/12/2004" UNION ALL SELECT c.site_id,c.date_survey,(c.hour_from + " - " + c.hour_to) AS hour, (isnull(d.volume_inc_post,0 ) + isnull(d.volume_dec_post,0)) as cnt FROM survinfo_2dir c,survraw_2dir d WHERE c.site_id= "SV01003LZ_MC" AND c.header_no=d.header_no AND c.date_survey = "7/12/2004" )ab GROUP BY ab.site_id,ab.date_survey, ab.hour )aa group by hour;
![]()