Search results for query: *

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.

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

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

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

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

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