Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access Functions, Access reports, Clustering, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database servers, DB2 administration, DB2 Universal Database, DB2 Web Query, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, LOOP statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, Primary keys, QMF, Query optimization, SQL queries, Sybase, Timestamp, Triggers, UPDATE statement VIEW ALL TAGS
I have a transaction table, There are 2 fields FuelLiters & FuelAmount. Both should be >0 or =0. If by mistaken FuelLiters entered as 0 and FuelAmount >0, computer should prompt about this mistake.
Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?