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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: crmorgan
  • Content: Threads
  • Order by date
  1. crmorgan

    Combo box to query

    I have a table that has a list of employees and the locations they know. The locations are fields. The data is in yes/no check boxes. For example, John knows Atlanta, James knows Atlanta/Miami/Nashville, and Jordan knows Nashville. Atlanta Miami Nashville John yes James yes yes yes Jordan...
  2. crmorgan

    If-then statements in report

    I have a report and I only want the field to show up if the field <30. For example IIF([field1]<30,[field2],"") I keep getting #Error on my report. I don't know where I'm going wrong in the formula. Thanks,
  3. crmorgan

    Calculating over 24 hrs

    I need help calculating time. I have a spreadsheet that calculates hours worked for employees. One column has clock-in time and the next column has clock-out time. The problem comes in when I have employees clock out on the next day. For example, he clocks in at 23:00 and clocks out at...
  4. crmorgan

    VLOOKUP auto-update

    Hi, I need to create a file that updates weekly with the corresponding week (i.e. File: 04-04-09abc will update with file 04-04-09 and the same will happen with File: 04-11-09abc. It will update with file 04-11-09) Is there a way that I can have the files link each week without having to redo...

Part and Inventory Search

Back
Top