using functions in a table??

D

D J R

I am trying to set a table that I am able to get results in another field.
the scenario is that in one field we record Sick days/day off and in another
field I wish to say weather the amount is acceptable or not. can anyone
HELP!!!!
 
J

Jeff Boyce

A scan through this newsgroup (tablesdbdesign) will show a consensus against
working directly in tables. In Access, tables store data, forms (and
reports) display it.

Access forms provide a much richer environment for controlling interaction
among data/fields.

Are you saying that the number of sick days/days off will determine
acceptability (making the second field a "calculated" field, and not
necessary to record), or that you need two fields, one for days, one for
approval/acceptance?
 

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

Insert Index into a Table 1
List all tables, including document structure 0
sqlite-odbc write conflict 2
A couple questions BEFORE using Office 365 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Mail Merge skipping records/sending one at a time 0
Adding data to MS Access from csv file 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0

Top