Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Tiredmom

    Bound Column - Need to show show other column on report

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

    Adding a checkbox in a query that populates based on another field?

    No, I am having trouble doing so. Thank you so much for your help though! I appreciate it greatly.
  3. Tiredmom

    SELECT statement in query

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

    Adding a checkbox in a query that populates based on another field?

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

    Adding a checkbox in a query that populates based on another field?

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

    DCount on Yes/No Fields

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

    Access Forms Problem

    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!
  8. Tiredmom

    Access Forms Problem

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

    Access - Date Manipulation

    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!

Part and Inventory Search

Back
Top