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.

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.

>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

>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

This article has been dead for over six months. Start a new discussion instead.