I wrote an Access database that tracks manufacturing data. I have some functions that query the data like this:
GetProcessYieldAvg(ProcessName, TimePeriod, StartTime, EndTime) as Double - example: PlatingProcess, Month, January 08, March 08 would return 93.8%
It returns the average monthly process yield for the Plating process between January and March.
I get a lot of requests for this type of data and I'd like to make the function available for others using Excel - so they're querying Access from Excel.
Is it possible?
GetProcessYieldAvg(ProcessName, TimePeriod, StartTime, EndTime) as Double - example: PlatingProcess, Month, January 08, March 08 would return 93.8%
It returns the average monthly process yield for the Plating process between January and March.
I get a lot of requests for this type of data and I'd like to make the function available for others using Excel - so they're querying Access from Excel.
Is it possible?