Recent content by subtilty

Looks perfect. Thanks!

Hi All, I have the following dloookup: txtcustomeremail = DLookup("custemail", "calldata", "Reg=txtbocid") And it works fine and brings back a value, however it brings back from the first row. I need it to bring back the matched email address from the latest row with the matching reg. Is this...

Great thanks very much.

If I enter it like that it automatically puts "'s around it. Is that causing an issue? I have also tried deleting the field from the query and re-entering it but still the same issue.

Hi thanks, I now get 'Data type mismatch in criteria expression'

Hi thanks for replying, yes they are stored as text.

Hi All, I am having a weird issue with a query. The date field in my table is set to general long time so: dd/mm/yy hh:mm:ss Now I perform a query: Between "01/05/12 00:00:00" And "03/05/12 00:00:00" and it works fine and brings back data for the 2nd. However if I change the query to...

Thanks NickHa... What a stupid mistake :)

SOLVED - Compile Error: Method or data member not found Good Afternoon all. I have the below code and am getting a Compile Error but the spelling is correct and the field exists and is named correctly. Code: CurrentDb.Exceute "INSERT INTO [Call Table](reportnumber, vin, code, agentname...

Hi All, I need help with a query, I am using Design View to create a query to find all fields of CC and HR value. Per Record there is 1 CC field, but multiple HR fields. How would I be able to have it so it brings back just the CC field and the last updated HR field? Thanks, James