Search results for query: *

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

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

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

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

The user highlighs it and changes the color.

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

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

THANK YOU missinglinq it works great!

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?

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

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

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

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?