[snip]
sqltext2 = "Select sum(orders.amount * products.price) AS total from
orders,products where orders.product=products.productid AND cluster = '" &
cluster & "'and orderdate > '" & printdate & "';"
[/snip]
If the query conditioals are the same for both queries you can just include
sum(orders.a
Hi there,
I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than
I what I did
I need to print reports via a website so I used ASP
It needs name,product, amount per item, price per item and total per
Hi there,
I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than
I what I did
I need to print reports via a website so I used ASP
It needs name,product, amount per item, price per item and total per o
