Microsoft DAP pages

[Trekk]

Hello

I have an access 2003 database which I am trying to create a few access pages from a couple of queries. I can create a page through the wizard with one of the queries, however I have 2 other queries that display data that I would like to add to the page that was created by the first query.

Is this possible. I have searched and searched and found nothing.

Thanks

 

[fneily]

Obviously the easiest way is to have all the data you need come from one query. Is that possible?
Or you could use a lookup procedure. See:

http://support.microsoft.com/kb/234301

Example:
<SCRIPT language=vbscript event=Current(oEventInfo) for=MSODSC>
<!--
Dim Con
Dim Rst

Set Con = CreateObject("ADODB.Connection")
Set Rst = CreateObject("ADODB.Recordset")
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test4.mdb;Jet OLEDB:System " & _
"Database=C:\Program Files\Microsoft Office\Office\System.mdw;User " & _
"ID=Admin;"

Rst.Open "SELECT Amount FROM [employee_table] WHERE ID2 = " & _
chr(39) & Document.All.Item("ID2").Value & chr(39), Con

Document.All.Item("Amttest").Value = Rst("Amount").Value

Rst.Close
Con.Close

-->
</SCRIPT>