Adding a new record

L

Luis Marques

I have a query based on a table with 3 fields ("Employee" Text, "IN"
(Yes/No), OUT (Yes/No).

I want Access just adding a new record, only if the field "OUT" of the last
record is "YES".

Is it possible?
 
D

Duane Hookom

I doubt this is possible in a table. I would use a form that had a combo box
to select the employee. The Row Source of the combo box would filter out the
inappropriate records.

BTW: why not use a single field and store either "IN" or "OUT"?
 

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

Similar Threads

Repeat fields from last record 4
A record problem 3
reording table after entering a new record 4
Default Values for a field 7
Disable-based on Adding New Record vs. Editing Existing fields 2
Historical tracking of records 3
What strategy to add a new record on subform? 2
date overlap 7

Top