I have an existing database with one field with financial figures ($00,000).
How do I setup a query where I can find those fields where there are either no entries (null)? or $0.00 dollar entries?
I realize its an OR operator within that particular column but how are the figures expressed?
Thanks.
mbsevans
Last Activity: Feb 14 '20, 06:38 PM
Joined: Oct 5 '06
Location:
-
Date flag in Access 2003
New Access user here. I have a simple datebase containing employee information. I have 3 differents dates which reflect the DUE date for a qualification that each employee needs in order to continue working on the job site.
I have looked at other postings but see nothing similar to what I am needing.
I need to simply have a flag (colour change or text) to alert a user that the current date is within a 30 day window prior to... -
Daily operations tracking with Access
Again, just a new user here but have been charged with creating a database that captures day to day activities regarding a very large construction job.
Parameters such as, plan inspections, safety walkdowns, new hires trained or oriented etc.
The biggest single focus here is producing concise monthly reports both in text and graphically, in order to report our progress or lack thereof, to our main contracting company.
... -
Access 2003 Security
New user here.
I have constructed a database to track basic employee information.
I wish to place finished database on a the network.
I need to obviously retain full admin persmissions for all aspects of the database.
More importantly I need to allow one clerical user to enter data and thats it.
Now...I have been through various explanations of how to set this up but none of it is making sense to me.
Even... -
Automatically flagging a date T+30 days
I have a simple database in Access which tracks employee information. These employees require regular security processing to continue working.
I have dates recorded for their last security screening, I need to flag or have an automatic prompt to inform the end user when we are 30 days out from the next screening due date.
Any suggestions for this rookie user?
Thanks. -
Forms and viewing NEW records
Relative rookie with Access here. Building a database to track contract workers. Fields consist of such things as name, first and last, employee number, and about 30 other pieces of data.
The problem I am having is this. Upon normalizing the database from one massive table to several smaller tables and creating a form for clerical staff to input and edit records, I am finding that when a NEW record is input it finds it way into the appropriate...
No activity results to display