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

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.