Search results

Did little more digging/investigating last night/this morning. Seems it has nothing to do with calling the VBA function with a table vs. query, but rather the fact that our live production query uses parameters. When I tested this in our test db calling query with no parameters works fine...

Good point. But I run that query by itself just fine with no problems.

I have a MedianG VBA function in a local test dbname.accdb that I call from a query to get Median for User1Line1, User1Line2, User1Line3 ... up to User1Line10. Works beautifully in test db. Today I copied VBA function/module into our live front-end dbname.accdb. I then took sql from...

Need help implementing way to obtain Median grouped by 2 columns and filtered by date in a Crosstab query. We use Access as front end reporting tool with linked tables to SQL Server 2008 backend db. Management wants a time analysis report of each performer by median (in seconds) per PO lines...

Newly registered member. I am located in USA (Eastern Time Zone). Have worked with Access off/on for many years but has been awhile. Consider myself with intermediate knowledge/understanding of programming. Forsee need for help and advice with current projects I got going on working with...