Search results

George thanks that worked a treat.

Thanks for this, only thing it still is returning 0 when I know that the date and time I am adding in are in the results of the query :-(

I have this If Not IsNull(strCount = DLookup("[Number_Of_Records]", "All_Booked_Callbacks ", "[CallBack_Date] =#" & Me.CB_DAte.Value & "#" _ & " And [CallBack_Time] = #" & Me.CB_Time.Value & "#")) Then strCount = DLookup("[Number_Of_Records]", "All_Booked_Callbacks ", "[CallBack_Date]...

ok managed to solve this in a really long winded way but it works :) See code attached

Ideally something like this.

If I try and explain what this is being used for it might help. This logs calls to people, they have three routes they can go down, initial, 2A and 2B, each has up to three calls, but different outcome criteria. The system reads the outcome code (from a contact table) and should turn that...

Unfortunately I do need to bring back the last column, so I guess I will need to try and do a second query to bring this back :(

Attached is what I am seeing The second column is the unique identifier, but if you look I have multiples, with the last column being the one that is pulling back too much data

Used the forum a number of times for tips and hints, never posted before now, but I really need the help.

I have the attached code in a query. It should be bringing back just one row for each record, however, if I have anything in any column other than Call_NUmber_int it brings back multiples if that record, I can't seem to get this right, any chance anyone can see what I have wrong in this...