Query based on a continous form

B

Blakey300

Hi

I am using access 2007.

With in my DB I have an add new students continous form which opens in data
entry mode so it does not show every student listed in the database.

I want to be able to create a query which I will attach to a command on this
this form that will only list every new student that has just been entered.

My reason for wanting to be able to do this is, I will then use this query
for collect data by email, so the user wont need to seach through every
student in the database in the create email wizard.

I hope this makes sense!!!

Dave
 
N

Noëlla Gabriël

Hi,

you could add a date/time field to the table with the default value set to
now(). Then you can easily query the records put in between [datetime1] and
[datetime2]
 
B

Blakey300

thats a great idea, i will give it a bash

thanks

Noëlla Gabriël said:
Hi,

you could add a date/time field to the table with the default value set to
now(). Then you can easily query the records put in between [datetime1] and
[datetime2]
--
Kind regards
Noëlla


Blakey300 said:
Hi

I am using access 2007.

With in my DB I have an add new students continous form which opens in data
entry mode so it does not show every student listed in the database.

I want to be able to create a query which I will attach to a command on this
this form that will only list every new student that has just been entered.

My reason for wanting to be able to do this is, I will then use this query
for collect data by email, so the user wont need to seach through every
student in the database in the create email wizard.

I hope this makes sense!!!

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top