Search results

So i have created a query and Max on the Record ID - this query stand alone works fine. I have another query that i then bring in the above query but its not giving me the latest record Query1: ID CustomerID Install Date EngineerNo Query2: Customer ID CustomerOrderNo CustomerInstallDate...

yep thats sorted it cheers

I am getting this error when exporting the Query to excel I have changed this: New Order Live: IIf([22].[Serial]=[New_Order]=True,"Yes","No") Results are Yes or No to New Order Live: IIf([22].[Serial]=[New_Order]=True,Yes,No) Results are 0 or -1 Which has now stopped the error, but i...

Thank you that did the job :)

nope

doesn't seem to work getting syntax error on CDate

Hello, I need to change the formatting of this strange date layout to standard uk date 2021-11-24T01:00:00.000Z 2021-12-13T11:18:10.684Z

Yeah i think you are correct will create a query with Max just to show last entry Thanks always :)

So we have a table that gets updated every day with the last events. like a log on the processing of any order The field that gets updated is called [Order_Status] and the date gets updated within the [ImportingDate] - what i need to do is once completed delete (or archive) all earlier records...

sorted it using this... Dim strSQL As String Dim ctl As Variant If IsNull(Me.TelephoneNo) Then Dialog.Box "Please enter a Customer Telephone Number!", vbCritical, "Data entry error..." Me.TelephoneNo.BorderColor = vbRed Me.TelephoneNo.SetFocus Exit Sub Else

Thanks no we always have a telephone number so how would i get this setup

Love to hear about the best way to prompt the user when they leave a field black Message - Please Complete Customers Telephone Number! - This cant be leave blank!

thanks this worked i had to rebuild the database and its all working now thanks so much for all your help =IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")

Ill export it into excel and use my original formula thanks anyway

yeah i have =IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")

STILL DOES NOT WORK

changed to -1 still doent work

no its not working see... yes for those with a yes i can also seeing the same when all 3 are the no BOOKED DELIVERED OUTSTANDING Expr1 No No No -1

yes for those with a yes i can also seeing the same when all 3 are the no BOOKED DELIVERED OUTSTANDING Expr1 No No No -1

No does not work as i said in my first post?