Search results

Forgot the SQL code :unsure: SELECT QryStatusReport3a.JobNumber, QryStatusReport3a.SumOfHoursWorkedTotal, QryStatusReport3b.SumOfHoursWorkedTotal FROM QryStatusReport3a INNER JOIN QryStatusReport3b ON QryStatusReport3a.JobNumber = QryStatusReport3b.JobNumber;

Thank you for your feedback I revised the query as shown below. The database itself has a jobnumber, start/end time, total time and a check box (true = working hours / not true =down time). The first query filters the total down time per job based on the checkbox value "False" and the second...

Hi, I have a query which calculate the total hours per job. These hours are split in working hours and downtime. But in case of only working hours I want the downtime hours filled with a "0" . I found a couple of threads on this topic but can't figure out how to use the code correctly. SQL...

Used the onCurrent option, problem solved! Thank you for your prompt reply!!

Hi All, I have a form on which a command button becomes visible if the value of a specific checkbox is true This works fine, but after I submit the form using the command button the form clears all the fields including the checkbox but keeps the command button visible. I have tried a few things...

Finally got it working.. I made all the fields with calculations bound fields (named them in my table 'calculatingfield1' 'calculatingfield2' etc.) instead of unbound textboxes and this did the trick. First of all thank you for all your help and suggestions!! But because I'm here to learn got...

Still the same results.. only returns the value from textbox28 regardless of the Textbox18 value..

No the field is called 'DiameterObject' Your code does the same and somehow only returns the value of [DiameterObject].Column(4) to textbox 20. Regardless of the value of numberofobjects

unfortunately still not working.. Textbox18 is a calculated textbox; =([numberofobjects]*[text12])+[text14] Textbox28 is a textbox based on a combo box; =[Object].[Column](4) Textbox20 is a unbound textbox The after update event is on field numberofobjects Textbox12 and 14 used in the...

After update of the field which is used for the calculated value of textbox18

Hi, There all Numeric values. If the value of textbox18 is greater then 90,120 or 180 depending on the current value of textbox28. Then the value of textbox18 should be used for textbox20 else textbox28 should be used for textbox20. Regardless of the value of textbox 18, If I use > it will...

Hi All, I made a simple If criteria, but for some odd reason the Else part of the criteria is not working. I am probably overlooking something simple, but I cannot seem to find it. Hopefully some can help. If Me.Text18.Value >= Me.Text28 Then Me.Text20.Value = Me.Text18 Else Me.Text20.Value =...