Query based on a continous form

  • Thread starter Thread starter Blakey300
  • Start date Start date
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
 
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]
 
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
Click to expand...
Click to expand...
 
Back
Top