Posted to microsoft.public.excel.programming

JohnDing[_2_] JohnDing[_2_] is offline

external usenet poster

Posts: 5

Run-query error

Hi,

I encountered an error while attempted to run a query in
a Excel-VBA subroutine to get data in a MDB database.
error reported as following:

Run time error'-2147217887'
You tried to execute a query that does not include the
specified expression 'Period' as part of an aggregate
function.

But I do have the field 'period', would somebody can help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
web query error	Vijay Kotian	Excel Discussion (Misc queries)	0	September 11th 07 10:22 AM
MS Query error	Ken W	Excel Worksheet Functions	1	April 6th 06 04:08 PM
MS query error	Ken W	Excel Discussion (Misc queries)	0	March 30th 06 01:37 PM
error using MS query	Ken W	Excel Discussion (Misc queries)	0	March 6th 06 03:47 AM
Web Query Run-time Error	AG[_6_]	Excel Programming	0	October 16th 04 02:17 AM

All times are GMT +1. The time now is 08:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us