Requery the 1st requery result which displayed in form

[vincentt via AccessMonster.com]

Hello all,

I have form with criteria that I want to search for, but it is not the exact
data in the table.

For example, I search whether students have book their class, hence, in the
query, I search whether Is Null in the book date field. Then I come out the
result and display in other form.

Now, I want to query the student who didn't book their class and find their
email, so that I could use mail merge in word to send email to those students.


Anyone could tell what should I do so that I could pull back the form result
into the new query? Or it is the problem of the design??

Thanks!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via AccessMonster.com

 

[Guest]

hi,

please post the design of your database (entities and attributes) so that we
can construct the required query which you can use in mail merge.

Regards,

 

[vincentt via AccessMonster.com]

Thanks and here you are:

tbl_studentinfo:
studentid
firstname
lastname
email


tbl_orderinfo:
orderid
studentid
bookingdate

And, if I query for the bookingdate Is Null, it comes out student A, B and C
who didn't book a date and should in the form.

How can I find out the email of student A, B and C (If it is a query, I can
use Word's mail merge)

Cheers!

hi,

please post the design of your database (entities and attributes) so that we
can construct the required query which you can use in mail merge.

Regards,

------------------------------------
http://www.Designing-Systems.com
Email. (e-mail address removed)
-----------------------------------------------

Hello all,

[quoted text clipped - 12 lines]

Thanks!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via AccessMonster.com