Search results

TwoDayStandard: Switch(EmissionStd = "A", 0.65, EmissionStd = "B", 0.35, EmissionStd = "C", 0.30, EmissionStd Not Like "*[ABC]*", 0) Note: EmissionStd is a table linked by relationship to my main table with EmissionStd being a column in the linked table. The code above is what I am entering...

When entering the code provided into a Query. The data sheet view still returns a #Error. Any idea as to why?

Does it matter if I have EmissionStd as a separate table with the column EmissionStd and choices A,B,C as rows? I get an error still when using the Switch Expression when trying to save. Could building EmissionStd as a separate table be the issue?

I currently have a table in which I want the VBA code to trigger based on a selection in another column. In the Expression builder for the table I can't make my VBA function fire like a built in function?

I want the code to execute once a user has entered the selection into the table column

I have a column called [EmissionStd] with Options: A, B, C. A = 0.65 B= 0.35 C = 0.30 Based on selection of A, B or C I would like Column [TwoDayStandard] to automatically output the numerical value based on the VBA code below. How do I call out the function in my table? My code below...