Multiple Queries on Same Form

[rajeshsarin]

Folks,

I want to design a form that looks like the following (see attached)

At intersection of each row and column I want to display the result of a query.

at intersection of visas and 15 days I am displaying result of following query.

SELECT Count(*) AS [No Of Visas Expiring in Next 15 days]
FROM Client
WHERE (((Client.VExpiry_Date) Between Date() And Date()+15) And ((Client.Status) Not Like "*Enquiry*"));

However as intersection of 30 days and visas I want to display result of a
different query, which is:-

SELECT Count(*) AS [No Of Visas Expiring in Next 30 days]
FROM Client
WHERE (((Client.VExpiry_Date) Between Date() And Date()+30) And ((Client.Status) Not Like "*Enquiry*"));

My question is how to display multiple query outputs at each junction.

Cheers

Raj

 

[llkhoutx]

Create a crosstab query. The crosstab query wizard is very good.

 

[rajeshsarin]

Someone suggested that I use an unbound form and Dcount function, can anyone guide me on how this can be done

 

[JamesMcS]

Same thing really, but dcounts are a bit slow, much more so than a select statement looking at the same data. Just have a look at the syntax of dcount in the help file.

 

[llkhoutx]

Try the crosstab query wizard.

Processing time for DCount on a small number of rows (10's of thousands) is generally not significant. 10 million rows is another tissue.

 

[JamesMcS]

Tell me about it LLK - I had 2 dcounts in one query, took over 2 hours to run, set them up as update queries, ran in 10% of the time. but yes, multiple millions of records.....

 

[llkhoutx]

Is your table a native Access table or some other database type?