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

  1. turks393

    access query help

    Correct dhookom. Sorry. I have a bunch of codes that i want grooped together and totaled up. I want them to be in order by day (that i got). So say i need a total of 24 of code xxx 8 by tue, 8 by thru and 8 by fri, i want to create them all at once, so my results in the query should show...
  2. turks393

    access query help

    I have a query that isn't grouping my data... I have a bunch of codes that i want to all stay together in the query and add the quantities up. there is also special instructions for maybe one or two of the codes and days that the code needs to be created. mon = value 1 tue = value 2, etc that...
  3. turks393

    Date range in acces report

    I have a query in access that is bringing up a date range Between [Enter Start Date (MM/DD/YYYY)] And [Enter End Date (MM/DD/YYYY)] I then used the report wizzard to make a report and in the header I want to show the date range that was entered. How do I do that. When I add the date to the...
  4. turks393

    Date range in access report

    I have a query in access that is bringing up a date range Between [Enter Start Date (MM/DD/YYYY)] And [Enter End Date (MM/DD/YYYY)] I then used the report wizzard to make a report and in the header I want to show the date range that was entered. How do I do that. When I add the date to the...
  5. turks393

    Add up formated numbers

    The user highlighs it and changes the color.
  6. turks393

    Add up formated numbers

    If in one cell you had blue number and red numbers is there any way you could total all the blue numbers in one cell and all the red numbers in a different cell? for example: John stopped for 0.5 hrs (blue), Bill ran for 0.8 hrs (red), Jill stopped for 1.5 hrs (blue), Joe was here for 8.5 hrs...
  7. turks393

    Adding computer name to a form/table

    Can the computer name be added to a hidden field in a form upon entry or exit of another field? For example... if you are entering data into bunch of fields, you are tabbing through once you enter or exit a date field the PC name gets entered into a hidden field and stored in the table. I am...
  8. turks393

    Disable mouse wheel from scrolling

    THANK YOU missinglinq it works great!
  9. turks393

    Disable mouse wheel from scrolling

    Is there an easy way to disable the mouse wheel from scrolling. I have a from for data entry and need to prevent people from scrolling. Can it just be added to the code?
  10. turks393

    Where can I find someone to help create a database?

    I am trying to create a data base that will look up infromation by an "account" number and if there is no current data then let you enter it. I will need to enter a few different types of numbers and would want to have names show up and populate a table. I know what I want it to do, but I...
  11. turks393

    Look up formuls for excel

    I got rid of the column 2 and now there are two comlums next to each other (column A is the low number and column B is hte high number. Column D has the number I want to come back. I tried this: =VLOOKUP(A13,'sheet1'!A5:B38,'sheet1'!D5:D38,TRUE) but it returns a #REF! A13 has the number I...
  12. turks393

    Look up formuls for excel

    I tried to have it use vlookup, but didn't get the results I was looking for. I have ranges (see below) on one sheet. On the another sheet I enter a $ amount (say $81.02) in one cell and I want the cell with the formula to read $5.00. If I enter 1,112.95 I want it to return $40.00. Can you...
  13. turks393

    Look up formuls for excel

    How do I have it look up the number entered on one sheet and if it is between two values then return teh number in the next cell?

Part and Inventory Search

Back
Top