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 Chriss Miller 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: PeanutB7
  • Content: Threads
  • Order by date
  1. PeanutB7

    Matching Two Columns From One Worksheet to Two Columns in Another While Returning a Value

    I am working with one Spreadsheet that contains two worksheets. I am attempting to match two columns in spreadsheet one to two columns in spreadsheet two. A respective number would then be inserted as the output from Column C Spreadsheet 1 Column A Column B Location...
  2. PeanutB7

    Excel Formula Help PLEASE

    Good Snowing Morning Folks, I am in need of a complicated formula for an excel worksheet. First off I need to scan a column of ID numbers that are sorted in ascending order in column A. For example 1234000, 1234001, 1234002, 1235000, 1235001, 1236000, 1237000, etc. If the ID number in...
  3. PeanutB7

    SImple Access Query

    Hello Folks, I have two tables inserted in a query that are linked together by last name. Table one has the last names with a designated title in a specific column labeled ID. Table two has the last names also, as well as many columns with a lot of assorted data. I need to add the title...
  4. PeanutB7

    Preferential Total

    Hello Folks, I have a very large spreadsheet (139,000 rows cut into multiple worksheets) with columns of data that includes various line item costs and a corresponding ID number. The ID number repeats itself providing multiple line items per each ID number. This would be similar to multiple...
  5. PeanutB7

    Conditional Shading off a Cell in Xcel

    Could someone please help with a conditional formatting situation. I am trying to highlight a cell with green for "On Time" and a red highlight for "Not On Time." I am using the formula listed below: =IF(L8>0, "On Time","Not On Time") I would like to add the red/green highlight to the...
  6. PeanutB7

    How do I subtotal groups in Reports with Access

    Hi Folks I am looking to subtotal each group in a report while stiull providing all of the record detail that makes up the subtotal. How would I go about doing that in an Access querry or report. I can create the querry which provides all of the records grouped by category. I just can not...
  7. PeanutB7

    Access Keyword Search Querry

    Hello Folks, I am attampting to build an access database by importing excel spreadsheets with rows of record data. Some cells contain text and some strictly numbers. I am ultimately attempting to querry all cells for key words that may fall within any cell within the record. For example...
  8. PeanutB7

    Looking for an "if" - "then" statement PLEASE

    I am attempting to go through a large spreadsheet with a first column containing 12 digit id numbers. Within the 12 digit number is an identification trailer on the very last digit. I would like to sort the spreadsheet by grouping any 12 digit id number that ends in 1, 2 or 3. If I had an if...
  9. PeanutB7

    Can you string more than seven IF worskeet functions?

    Hello, I am trying to string 18 IF worsheet Functions together in order to evaluate input data from a worskheet in order to establish a corresponding scope priority in column V. For example if given a "H" in column S, a "H" in column T, and a "L" in Column U using the line 285 from the look up...
  10. PeanutB7

    Lock work sheet formulas while pasting new data

    Dear Incredibly Helpfull People, I am trying to lock all formulas in a complicated worksheet as a template while pasting new data in for various regions multiple times. Is there a way to protect all formulas within a worksheet but allow to overlay new data without overiding the needed...
  11. PeanutB7

    Need to round up 27,890,000 to 28 in a spreadsheet - PLEASE

    I am working on a spreadsheet in which I would like to count all in millions. Therefore I need to round up all numbers to reflect millions and billions only. For example a number like 27,890,000 would be shown in my spreadsheet cell as only 28. I would prefer not to have to create a new...
  12. PeanutB7

    Need to validate start date is less than end date on a form

    Hi folks, I have a form presently that includes a start date and end date for projects. These dates are saved to a table and are critical in calculations of hours per day for project time analysis. The data input folks are regretfully reversing end dates with start dates and ending up with...
  13. PeanutB7

    Reduce Multiple Query Parameter Selections

    I have a database running three parameter queries requiring dialog boxes for each. The user is asked to "Select a start date in the format xx/xx/xxxx" and the same for an end date. The selection for all three queries must be the same for proper reporting. For reasons of accuracy and...
  14. PeanutB7

    Access Date Range Query

    Hi Folks, I am looking for a query to a calculate data within an Access Table. The Table contains project records with specific Start Dtaes and End Dates as columns. With a parmater query I am having the reviewer select a date range. I would like Access to view each project record and state...
  15. PeanutB7

    Date Query to Calculate Term

    Is there a query (or series of querries) I can perform that will: 1.)Look at two columns of info per record from a input data table - first START DATE - second END DATE - and then calculate a "length of term" in months. 2.)Next I would like it to take a TOTAL HOURS column and divide the TOTAL...
  16. PeanutB7

    Exporting Access Report to Excel

    I have created a very complex detailed report in Access Design View and would like to Export it to Excel for storage and adjustments. Regretfully my detailed report comes out as one line with Text Box as the headings and data below. There is no resemblance to my report and nonlegible data as...
  17. PeanutB7

    Find Record Command Button asking for argument - Find what?

    I have include a find record on a form and used the button wizard. Regretfully it is coming up as an error asking find what? The Action Failed Dialog Box States: Macro Name - Find Record Condition - True Action Name - FindRecord Argument - ,WholeField, No, All, No, Yes, Yes Could anyone...
  18. PeanutB7

    Fill all Null Cells in Excel Spreadsheet with zeros or later in Access

    I am looking for a tip on how to fill all null cells in a large excel spreadsheet with zeros. I am loading the existing records into an Access database and I need to have the empty cells contain zero in order for calculations to function correctly. Is there an Access function that would...
  19. PeanutB7

    Find Record Command Button asking for argument - Find what?

    I have include a find record on a form and used the button wizard. Regretfully it is coming up as an error asking find what? The Action Failed Dialog Box States: Macro Name - Find Record Condition - True Action Name - FindRecord Argument - ,WholeField, No, All, No, Yes, Yes Could anyone...
  20. PeanutB7

    Exit Form but do NOT save record not working

    I have tried using the button wizard for Exit Record with no save which uses a macro but the record still is saved. I haved written the DoCmd: DoCmd.Close acForm, "ProjectInformation",acSaveNo and it still saved the record. I have been told to include: IfMe.Dirty then Me.Undo but I am not...

Part and Inventory Search

Back
Top