a combination query

[ariansman]

Query1 has one result like the following

ID   studentname    lectureplace       lecturesubject
23        jack           A             Geography

Query2 has results like the fowloing:

ID   studentname    lectureplace       lecturesubject
12        jack           A             Biology    
18        jack           c             politics    
20        jack           B             math    
22        jack           A             math    
27        jack           B             math
29        jack           A             politics

A table or query is required which has the record from query1 and those records from query2 whit ID greater than the ID of the record in query1. The following is what the result is like

ID   studentname    lectureplace       lecturesubject
23        jack           A             Geography    
27        jack           B             math
29        jack           A             politics

Thank you

 

[plog]

I would create a query based on Query 2, then underneath the ID field, in the criteria section I would use a DLookup into Query 1 to retreive the ID.

 

[ariansman]

I would create a query based on Query 2, then underneath the ID field, in the criteria section I would use a DLookup into Query 1 to retreive the ID.

thank you,
and would that also add the query1 data? plus, how can i make a dlookup? i am not good at writing such things.
thank you

 

[gblack]

If there's really only one value in query 1... or if you always want the biggest ID value in query1

I think you could just write a subquery in your New Query...

For Example:
> (Select Max(ID) From Query1)

 

[plog]

I would not add query 1 to this new query, the Dlookup will get you what you want. Here's a link to how to run a Dlookup: http://www.techonthenet.com/access/functions/domain/dlookup.php

 

[gblack]

I thought a subquery might be faster...no?

 

[plog]

I do not know.