Recent content by Lochwood

Crosstab Query PARAMETERS [Forms]![Work]![Job Number] Short, [Forms]![Work]![Cancelled_Check] Bit; TRANSFORM First(DateAdd("yyyy",+3,[Date_Last_Dem])) AS Dem_Due SELECT Historic_Assignments_Query.Assignee FROM Historic_Assignments_Query INNER JOIN (Comp_RPM INNER JOIN Comp_RPM_Reg ON...

I have a crosstab query that is dependent on check boxes and feeds a max query. sometimes columns dont exist due to boxes not getting ticked. How can i ignore a field in the max query if its not present. currently shows an error because it cant find it in the mAX query.

Ill see what i can come up with.

I have employees with certain tasks completed and each task creates a new record. I am looking to change the format so all tasks run as colums across the top and have created a crosstab for this purpose but it creates multiple rows for the employee. is there a way to merge the data into a single...

Genius.. Thanks Minty works perfect.. your caffeine count is fine 👍

You've caught my fatal flaw. yes if date <date() then it is also EXP

I am looking for help with the syntax for 3 conditions in my query. Basically if [Date] is Null the calculated field called [Status] will be "NO" if [Date] between Date() and Date() +30 "EXP" and if [Date] >Date()+30 "YES" Here's what I've done but can only get it to display the first...

Hey guys i got this fixed. In my code i run 2 queries and before they run we have a msgbox prompt. if clicked yes it runs the queries but before it runs them, it populates 2 fields on the form with username and Now(), these fields are then used to populate fields on the first query and...

the append query appends the data to a history table before the update query runs so we have a copy of the data before it changes. there may be a timing issue but i dont think so. here is the error i get on the update query that runs after the append. Tried the DoEvents but same issue

I have an append Query and an Update Query which i run via a button on the form. If i run them manually both work fine but if i run them from the button, the append query works but the update query doesnt as though the append query is locking the record some how but as i said if i run them...

moke123 thanks man. 👍

theDBGuy Yip and that fixed it 👍

thanks Gasman.. worked a treat