Search results

Hi I have changed the queries that needed to be changed and the database has been extensively tested and is working OK. I don't think I have missed any. Why would the foreign keys change? Sorry I am not understanding where you are trying to guide me.

Thanks, First - ZLS - Zero Length Stuff? The source data is coming from an excel report that is imported into a table file. The data is not altered at all at this stage. Yes there was another query with a problem, for data from a different excel report. So something new I have learnt to look...

Hi, correct TSPort and POD cannot be null. Thank you, that makes sense.

Yes, that sorted it. I did not expect adding the data to a sharepoint list would make that conversion. Something to store away for later. I wonder, instead of Nz() in the function call is it possible to amend the function? I had a go but manage to get no where. Thanks for your help and sticking...

Hi, Thanks for the suggestion and the help. That didn't solve the problem but I think I am 90% there now. For some reason when moving the data from an Access table in a network drive to a sharepoint list these fields are no longer "empty". I have tried entering different expressions into a...

Hi, yes error in the query output. SELECT TSOperationalPOD([TS Port],[T/S 1],[T/S 2],[T/S 3],[T/S 4],[T/S 5],[POD]) AS [Operational POD], tblTranshipmentReports.[TS Port], tblTranshipmentReports.POL, tblTranshipmentReports.[T/S 1], tblTranshipmentReports.[T/S 2], tblTranshipmentReports.[T/S...

Hi, I run the function in a query across a selection of data. The data populates in the query but for the OperationalPOD I get #error.

Hi, thanks for your help. The revised code is simpler and I think I have a slightly better understanding of how to use the Select Case but unfortunately it works the same as my earlier code. That is, it works with data in a table that is in the database but not with data in a sharepoint list. I...

Hi, I have an Access database that has worked well for the last two or three years. My organisation is moving from a network with shared drives to O365 and Sharepoint. The database is a split database with multiple users. I have been trying to move the tables to sharepoint lists (I am sure a SQL...

Hi, I am from Auckland NZ. I am self taught in MS Access and a little bit of VBA in excel. SQL is another mystery that I have dabbled on but only when I have to. So I often struggle with the correct terms and syntax but normally get there in the end. I have generally used the old sledge hammer...