Recent content by Wozza

Yes, I got it to work in the query. I did need to put in the table name though for it to work. 'SimpleCSV("SELECT LE_shortname FROM MT_guarantee_list WHERE REF='" & [MTR_Proj_info].[Ref] & "'"). ow to try and get it working in the form. Thank you so much for your help

Hi, I used your function and the code your suggested but still keep geeting the #name? error

Thank you. Yes I will take a look. :)

Feel like I'm so close! It's now coming up with this....

Hi, I am using Allen Browne's function to try and concatenate values from a related record in a form. However, the concatenated field is not working properly. This is the table So I need 20FUN02 - JCM, ICFO. In the form, it is coming up as The code for the guarantee list is ...

OK, thanks, I will have a look at DMAX + 1

Hi, the table is used in other databases so ideally would like the numbers stored in the table, but totally get your point.

Hi, I am trying to create a unique case study reference number based on project ID and then a number. So far I have created a query which gives me the number, however, I can't then update the generated number into my table (I know it has something to do with the query not being updateable). I...

Thank you. I've been playing around and now have it working. :)

Hi, unfortunately it didn't work

Hi, thank you for taking the time to reply. However, when I run the query, it comes back blank. Any ideas why?

Hi, I have a query where I want to allocate a number to each of the projectID's. e.g. 14IND01 has 4 records, how do I get a list showing 14IND01 1, 14IND01 2, etc. Thank you in advance for your help.