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: phpatrick
  • Order by date
  1. phpatrick

    join all tasks

    YEAR MNR ID TASK MAAND TOTUURSHIFT1 2006 08 4 WORT august 49,13 2006 08 3 POMP august 8,68 2006 08 7 ONDE august 3,77 2006 08 6 GRAS august 3,82 2006 08 8 DIVE august 171,55 2006 08 2 COUR august 118,25 2006 08 1 AARD august 124,55 2006 08 august 0,00 I have this question : there are for...
  2. phpatrick

    calculate percentages

    It works fine. Perhaps some syntax trouble. Now there is no need anymore to post my SQL, I do this for my future requests. txs
  3. phpatrick

    calculate percentages

    You have reason. I copied the working part in my previous but little problem remains, he refused to take the percentage property.
  4. phpatrick

    calculate percentages

    [TOTAL]/DSum("TOTAL","TABLE_TOTAL") AS [PERCENT] set the propertu of the field to percentage merci, this works in a new query. when I try to include this in the same query (where he calculate the totals, this is not working. I suppose you can't make some calculations on another calculated...
  5. phpatrick

    calculate percentages

    Jeff, I do not see the need of Column2.
  6. phpatrick

    calculate percentages

    SELECT ColumnTotal/Sum(ColumnTotal) * 100 As ColumnPercentage From Table What is wrong, he refuse to take this, he said, not part of statistical function ?
  7. phpatrick

    calculate percentages

    COLUMN 52,24 255,11 0,3 I need to get the percentage of a column. I think I should first find out the total. Then divided and multiplied with 100. 1. How to get the total of the row. Is it possible to put it directly in my expression ? 2. Is the formula correct ? number/total * 100
  8. phpatrick

    3,49

    yep, txs - 3 houres and 30 minutes is 3.5
  9. phpatrick

    3,49

    I used along time DateDiff to calculate the minites between two timespans. 8:32 till 12.21 : should be 3:49 (tree houres and 49 minutes) I got 3:81 with my code. Are the minutes here from 0 to 100 ? DateDiff("n";[SHIFT1VAN];[SHIFT1TOT])/60) If I want totals won't I make the sum of 3:49 and...
  10. phpatrick

    union query

    Why not ? access foresee that you can add records along queries. I looking for the next solution. I got one query with only the new records of today. But I like if the user did not close a record (he or she forgot to put a time in the previous days) that he show this records to. I try to fix...
  11. phpatrick

    all previous days

    what is shorthand to put in my query on a date field to say that he should show me all the records where the date is in the past. So every day of the past except today. Is it possible to say NOT NOW() ?
  12. phpatrick

    union query

    I wonder I make one query out of two. I got an union query. Ones you got this union query can you add new records to this ?
  13. phpatrick

    timediff()

    You have the function DateDiff to get the number of day between two days. What is the most easy way (function) to get the minutes, hours between two times. setuptime 14:00 finish time 17:18 = 3:18 I should put this function in a where clausule of my query.
  14. phpatrick

    total columns

    its ok, I got my result, perhaps not in the best way, but it works. I used 3 TimeShifts. Morning, Afternoon, Evering. I was concerted to put this in one field. I think I could not manage this in my form and report. Each contactperson put his timeshifts in the form.
  15. phpatrick

    total columns

    I tried the function Nz. Thats not ok. When I have two values in two colomns, column1 = 1 and column2 = 0 then I get 10 and not 1 for the totals.
  16. phpatrick

    year from mars to mars

    what is the selectcriteria to say on a date field I need the datums from 1 april until end mars of the year after this. In most cases you ask the data of a certain year. Thats easy, you can use the format function. But here the year is from 1/04/2006 until 31/03/2007. I need to tell this to...
  17. phpatrick

    total columns

    1. perhaps, but not much experienced with crosstab queries. I looked up some examples of crosstabs and the data of the time for example where grouped in one fields. I have tree different SHIFTs columns. 2. to counter the problem of the fields where there is not a value for, I ad this...
  18. phpatrick

    total columns

    SELECT Q_001.TEELT_TAKEN, Q_001.AantalVanrefTEELTSHIFT1 AS SHIFT1, Q_002.AantalVanrefTEELTSHIFT2 AS SHIFT2, Q_003.AantalVanrefTEELTSHIFT3 AS SHIFT3, [SHIFT1]+[SHIFT2]+[SHIFT3] AS Expr1 FROM (Q_001 LEFT JOIN Q_002 ON Q_001.TEELT_TAKEN = Q_002.TEELT_TAKEN) LEFT JOIN Q_003 ON Q_002.TEELT_TAKEN =...
  19. phpatrick

    total columns

    ok - SHIFT1+SHIFT2+SHIFT3 works but little problem remains. If there is nothing for SHIFT3 or SHIFT2. He is not counting, making the totals. Should I work with iif or is there an easier way
  20. phpatrick

    total columns

    SCHIFT = column heads This is a query and I like the total of the 3 columns (SHIFT1+SHIFT2+SHIFT3). When I try to refer to in an extra column to these columns in the same query (to make the sum), he can't do this. e.g. COUR = 128

Part and Inventory Search

Back
Top