Search results

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

if its unchecked then the other 3 conditions must not be null if its checked then they dont basically NA checkbox.

Easy one, I have 2 conditions that will create and "*" when conditions are met. so 3 fields must be NotNull and checkbox must be unticked or checkbox is ticked When i use the or statement all i get is -1 so thinking my syntax is wrong. 1: IIf([Security_Checked_Date] Is Not...

where would i add this to the current string please?

Due_Date: IIf(Not IsNull([maxof1st_date]),Format(Day([MaxOf1st_Date]) & "/" & Month([MaxOf1st_Date]) & "/" & Year([MaxOf2ndDate])+1,"Medium Date"))

MY query creates a calculated field based on 2 dates.. it takes the day and month from 1 field and the year from another to produce a renewal date. This works perfectly but i am trying to add conditional formatting to this field and it aint working. I am thinking because it is a calculated...