Search results for 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...

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

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,

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

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!

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