Search results

I have a query that is causing this very problem. i have looked at the joins and none of them are the same. can't see the trees for the leaves arrghhhh if it would just tell you which table is causing the problem. i have deleted relationships easier than this in real life :banghead::banghead:

All good i realised. just sending base data to tables and sending that data to a query that will calculate again the same fields that wouldn't flow through. I have the total cost, quantity and rate to please everyone who needs to see it because sometimes we will split hours into 3 to 5 costcodes...

:banghead:I have a table that stores all information from multiple forms to then send to different areas. in each form the below is a problem. I created calculations and cascade boxes. kept it as simple as possible. I have seen different answers to send the information from an unbound text box...

I was missing the parenthesis before the Datediff. How simple was that to solve. I had been trying that bloody code exactly as you wrote it but it wasn't working and I never thought to surround the DateDiff with rounded brackets. I didn't use End in Table, I couldn't be bothered writing...

i need an expression in a form to get times worked in a day minus breaks. the fields are eg: Start 06:00 Break 0:45 End 18:00 I need to do following in expression. for a form cell. Start-Break-End/60 = Total Quantity eg: Datediff("n",[Start],[End]/60 but how do i incorporate the Break...

I have been searching all weekend and running out of time. it is final part to the puzzle and I am so over it. head is hurting and tired. I have a form. it needs to have a total quantity and total cost Start Breaks End I need to do following but expression hates my formula...