I am working on a database that uses a lookup field called Job Family that contains two pieces of information, a category number and a descriptor. Ex: 1 = Executive, 2 = Director, 3 = Supervisor, etc. There are only a dozen entries altogether. I use the first column (the category) for...
I am having trouble in a query. I have tried to build the following statement with the intention of populating a Point Status field but only when the position is filled. The following is what I tried but I get various error messages.
Expr: (SELECT[T:Posting Master].[Pt Status] FROM [T:Posting...
Thank you for responding. I do have the date criteria built in. I just am looking for a way to differentiate the "older" postings from the newer ones. I want to be able to set up a report that will set aside the older postings, that's why I was wondering about a check box.
I have set up a query using multiple criteria. I am tracking (for our recruitment area) how many positions are open, how many were posted in the last week and how many were filled in the last week. I have all this data in a query but I would like to delineate those positions that are over a...
Thank you Joe. I tried both and that did not work. It's almost like the forms are really not there. I can't open in form view, design view or even delete them!
I have a database that we have been using for over two years. Several forms and reports run using a switchboard. When I came in this morning the switchboard didn't work. I can go behind the scenes and open all the tables, the queries and the reports. However, I am unable to open a single...
We are in the process of designing a database that tracks referral bonuses. Bonuses will be paid after an employee has completed both 90 days and one year of employment. I need help with the formula that would take Date of Hire and add 90 days and 360 days. Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.