Search results for query: *

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...

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...

I need to count how many yes and no answers I get in a certain field in my database. Would DCount be the function I would use?

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!