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

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

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

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.

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

TEELT SHIFT1 SHIFT2 SHIFT3 WORT 284 246 10 COUR 101 24 3 DIVER 80 62 33 this is the result of a query. how do I make the sum, total for each row (I need the total to get the percentages). e.g. total of row two should be 128. Is a crossquery a way to solve this ?

I have a continious form. When I am on a certain record and I use the event onclick on a textbox he should dropdown the listbox beside the textbox (in the current record). How to select the list-box of the current record. Me.Requery Me.Recordset Me!refDropDown.SetFocus...

I know you have recordcount but can I use an sql statement to determine if a query has data (records) or not. on the event open form he should verify if the query contains more then one record.If yes he should open a form that is normally not visible. Form.visible = true

WEEK: DatePart("ww";[DAG];2;1) I need a query where he select the values of the previous week, how to do this. This is weeknumer 2, so I need the records of previous week, this was weeknumber 1 This can't be hardcoded, because every week you got a new previous week

SELECT [ID_TIME], [WEEKDAG], [WEEK], [refCCT], [PRESENT], [NAME], [CCTNAME], [CCTFORNAME], [DAG], [SHIFT1VAN], [SHIFT1TOT], [refTEELTSHIFT1], [SHIFT2VAN], [SHIFT2TOT], [refTEELTSHIFT2], [SHIFT3VAN], [SHIFT3TOT], [refTEELTSHIFT3], [PLUS], [MIN], [PLUSMINUTES], (SELECT Count(*) FROM Q_04_TIMEDAG...

hi, I use a report with multiple pages. I like to print the current page after a check of the data. Of course you can manualy select the page and print along the dialog screen but can I do this quicker by a botton on the report or an event on the report page ? thanks

perhaps its a dump question, but I can't find it right now. I have a calculated field in my query and I like to limit the decimals to 2 digits. I looked in the properties, but this is not mention decimals. This query feeds my report, here I can limit the decimals, but he takes the complete value...

Hey, In my query I have an expression that gives me the number of the week : [WEEK: DatePart("ww";[DAG];2)-1] This query is feeding a report. This report should give me only the data from the last (recent) week. The highest weeknumber is 37, how do I get this number in my SQL where clause ...

I created a report and I narrowed the default margins to left and right 5. I save this. But while manipulating the report he always gets back to his default setting, how can I avoid this ? thanks

Perhaps an easy one, but I can't find. Looking for the weeknumber, this works but start on Sunday. European weeks start from Monday. I uses vbMonday, but syntaxis is refuses. Any ID

Me!refSHIFT1.SetFocus Me!refSHIFT1.Dropdown This code dropdown a combobox. However, I use a continious form, where the combobox is multiplied for more records. He always dropdown the combobox on top en not the last added record. How can I say that he need to select the last one ? regards

hi, I like to set the title of the listbox on top of the list with a sql statement. I've seen something like below, but you need another query, I do not need a query, because my title of my textbox is not in a query. SELECT 0, " CANDIDATES " FROM [Q-01-FIRM-CANDIDATES] UNION SELECT...

Hello friends, Situation : A simple form with one textbox field "person". Because it is subform, on my form I get a list of persons. Each person has to click another field "time" to set his current time (intake). Problem : it happens that a person clicks the timefield with is not related to...