Recent content by t long

  1. t long

    query excluding zero values

    In the Criteria Row (because I used Wizard to create the query) the folowing formula is already in the criteria section In (SELECT [Position #] FROM [Bde HQ Staff] As Tmp GROUP BY [Position #] HAVING Count(*)>1 )
  2. t long

    query excluding zero values

    I have a query to find duplicate values in my "position #" feild Several of my position numbers have a value of zero and I want to eliminate them from the query so I dont see them - how do I do this Thank you
  3. t long

    Need a formula to lookup a value in a query or table

    OBP - If you figure anything out with the db that I sent you could you send it to my home email address too at [email protected]
  4. t long

    Need a formula to lookup a value in a query or table

    Sorry Guys - I tried to receive the file that db1 that slurpee55 sent me but my computer wont allow me to either at work or home, and If I knew how to upload the database that I am working with now that I have posed the question about I would - maybe I could email it to one of you?
  5. t long

    Need a formula to lookup a value in a query or table

    Thank yo SOOOOOOOOOOOOOO much - let me know when you have something
  6. t long

    Need a formula to lookup a value in a query or table

    Slurpee55 - can you send me that zip file via email [email protected] Thank you
  7. t long

    Need a formula to lookup a value in a query or table

    I have an access database that keeps track of participant in competitive events Depending how a person places & how many participants they competed against in any given event determines how much money they win & are paid up to 4th place. for 1st place winners they would receive 35% ( times...
  8. t long

    Need a formula

    Sorry - our firewals wont allow me to open the zip file could you email it to me at [email protected] Thank you
  9. t long

    Need a formula

    Sorry - Access 2003
  10. t long

    Need a formula

    Hello I need a fomula that will calculate the amount of money a person will be awarded depending on #1, what place they came in and #2 how many people they competed against based on the amounts below. # competing against 1st 2nd 3rd 4th...
  11. t long

    Dates are off - Please Help ! - I'm not an expert.

    My name is Cpl TL Long and I am trying to create a spreadsheet that will calculate the amt of days we are entitled to when we leave Afghanistan. I've gone over the formulas and I cant wrap my brain around the reason why sometimes it's off a day with the END DATE Here' the explanation of...
  12. t long

    Weekdays & Weekends formula - HELP

    I need a formula that will take the Start Date in cell A1 and add the number in cell B1 to it exluding weekends (sometimes It is either 1 day too much or one day too less - using the WORKDAY(A1,B1) function. If the start date is 12 Feb 2007 and I want to add 5 days, I need it to include the...
  13. t long

    Formula (workdays) Help !

    I Need A Formula That Will Take A Date In Cell E37 And Add The Value In Cell B39 (lets Say B39 = 7) - However I Want It To Exclude Saturdays Or Sundays And Have The Answer In Cell E39. So Esentially I Need A Formula That Will Add A Certain Amount Of Days To A Date Not To Include Saturdays And...
  14. t long

    Excel fomula

    :( I need a formula that will calculate and issue a point for each month that a person works. Here's the trick though, For partial months a person is considered to have worked a full month when there is 10 or more days worked- for example. 01 Mar 06 - 31 May 06 = 3 points 29 Jun 06 - 10...
  15. t long

    Need an Excel FORMULA - PLEASE HELP!

    OK - I need a formula to calculate the following In Cell A1 I will enter a number anywhere from 0-1000. In column B (I have a list from 1-1000) and in column C (I have what each numbe from column B will return with a LOOKUP formula - lets say they are people's names) If cell A1 is equal...
Top