0

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.

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by carylle
0

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.

0

>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
0

>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 topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.