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: *

  1. crmorgan

    Combo box to query

    I used this formula to generate my data for one [Location]: IIf([Forms]![Frm_OpenReports]![Combo12]="Atlanta",False,True) How can I get it to work for all locations in the query? For example, I want one query to pull data for either Atlanta, Miami, or Nashville. Once the locatin is selected...
  2. 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...
  3. 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,
  4. 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...
  5. crmorgan

    VLOOKUP auto-update

    Hi Yogi, I hope this clarification works. I have two files of different workbooks. One file is titled "04-04-09" and the other is titled "04-04-09abc" I used VLOOKUP to populate the cells in "04-04-09abc" with the data that is in "04-04-09". Thanks for your help!
  6. 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