Recent content by phpatrick

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

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

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

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

Jeff, I do not see the need of Column2.

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

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

yep, txs - 3 houres and 30 minutes is 3.5

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

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

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() ?

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 ?

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.

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.

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.