Search results

JHB, Thank you! This does exactly what I was trying to get it to do. Thank you so much for your help. :) Do you have any suggestions for websites I can visit that have good Access Tutorials I could view? bc_newbie

JHB, This is still new to me but I am trying to learn how to do this with the help you all are providing. I tried creating a UDF to split the contents of the Schema field as spikepl suggested. I'm having trouble with the DLookup function to retrieve the corresponding location name. Can you...

Anyone know how to do what spikepl suggested?

Hi spikepl, Can you PLEASE help me write that? I'm not familiar with how to do it. bc_newbie

Hi Gina, The values for the Schema column are stored in the MonitorPoints table. Those values are somehow pulled in from a third party software into the MonitorPoints table in the access database. I apologize, I think I posted the wrong code earlier...I've been trying a few different lines of...

Hi all, I am very new to Access but have a basic understanding. Can someone help me to modify the code below to Show the LocationName in the Schema Column instead of the MPID? I attached a pic showing the relationship between the two tables which contain the data I'm trying to query. Thank...