I am trying to display the result of more than two queries in one table. Is there anyway of doing it?

You gotta be a little more specific that that.

Are you looking for something like:

"select item1, item2, item3 from table"

????

Who are the two queries?

I really don't know what you really looking for Sukuti..but I am assuming that you want something like this:

(asp display)

Execute SQL1

Set it to RecordSet --- RS1

Similarly, Execute SQL2

Set it to RecordSet -- RS2

Now,

Loop RS1 to display...something like

With Response

.write ""
While RS1.EOF = False
.write ""
RS1.MoveNext ' move forward
Wend

' Now repeat the same process for RS2
While RS2.EOF = False
.write ""
RS2.MoveNext ' move forward
Wend

' finally close table
.write "

" & RS1("Value") & "

" & RS2("Value") & "

"
End With


OR.....

You can join those two tables and create a view....and treat it like a single talbe....

I hope it helped a little...

I was trying to create a view.
I got it working now.

Thanks a lot guys...


select count(dns_name) as units_completed_today,
count(distinct store_number) as stores_completed_today,
(select count(distinct store_number) from asda.stores where scheduled_on = '2004-07-07') as stores_scheduled_today,
(select count(dns_name) from asda.dns_names where replaced ='Yes' and serviced = '2004-07-07') as units_replaced_today,
(select count(distinct store_number) from asda.dns_names where serviced is not NULL ) as total_stores_completed,
(select count(dns_name) from asda.dns_names where serviced is not NULL) as total_units_completed,
(select count(dns_name) from asda.dns_names where replaced = 'Yes') as total_units_replaced
from asda.dns_names
where serviced = '2004-07-07'

Good luck

I have created a view for a report that shows the summary of events that took place on everyday basis. so I set the timestamp as now(). but what happened was, on my view now() converted into a fixed date (the date I wrote the view), and the summary is not showing the info about the current day, but it is still showing the info about the day i created the view.
how do i get it to where i am seeing the events that happened today, i mean on current day?