i am creating billing system and i need to display daily and monthly billing reports. can you help me in displaying the billing reports using select statement? thanks.
carylle 0 Newbie Poster
carylle 0 Newbie Poster
i am creating billing system and i need to display daily and monthly billing reports. can you help me in displaying the billing reports using select statement? thanks.
can i ask for sample codes?
i'm trying these code
SQLquery = "Select sum(amountdue) from TABLE where FIELD
. . . . "
i am out of codes, i don't know what to follow...
thanks to anyone who could help.
kvprajapati 1,826 Posting Genius Team Colleague
>can you help me in displaying the billing reports using select statement?
Of course, SELECT SQL statement is used to fetch rows from the database but you have to learn/use crystal or microsoft or open-source report writer tools.
>i need to display daily and monthly billing reports.
Daily (date wise),
select * from tableName where transaction_date='02/15/2010'Monthly,
Select * from tableName where month(transaction_date)=2 and year(transaction_date)=2010 carylle 0 Newbie Poster
>can you help me in displaying the billing reports using select statement?
Of course, SELECT SQL statement is used to fetch rows from the database but you have to learn/use crystal or microsoft or open-source report writer tools.
>i need to display daily and monthly billing reports.
Daily (date wise),
select * from tableName where transaction_date='02/15/2010'Monthly,
Select * from tableName where month(transaction_date)=2 and year(transaction_date)=2010
it's a fixed statement, but it's helpful... thanks
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.