Query based on a continous form

[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

 

[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]

 

[Blakey300]

thats a great idea, i will give it a bash

thanks

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

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