Search results

No, but I can tell you this: [Premium History Data] is a linked table from one database and GetPriorPayPeriod accesses [Admin Data] which is a linked table from another database. I've tried making [Admin Data] a native table to the front end database and it's still not working. And, I've had no...

I have done that and the Query works properly. It's only with this Pay Period that it's happening. Yes, values for the Pay Period do exist.

I have the following saved Query: SELECT [Premium History Data].Premium FROM [Premium History Data] WHERE ((([Premium History Data].[Pay Period])=GetPriorPayPeriod('County','Selected'))) I've stepped through GetPriorPayPeriod WHILE running this query and it returns the correct result (in this...