You tried to execute a query that does not include the specified expression... - execute query - order by pertinence

ParAccel Announces General Availability of New In-Database Analytics Libraries in Partnership with Fuzzy Logix

The Integration of the ParAccel Analytic Database (PADB) and DB Lytix from Fuzzy Logix Provides a High Performance, Best-of-Breed Platform for Predictive Analytics.

Press published on the March 14th, 2011 - 6:00 AM ET

Revolution Analytics and Jaspersoft Partner to Deliver Best-of-Breed Business Intelligence and Predictive Analytics

“RevoConnectR for JasperReports Server” brings the power of advanced R analytics to enterprises through Jaspersoft reporting and dashboards.

Press published on the March 2nd, 2011 - 7:02 AM ET

You tried to execute a query that does not include the specified expression...

I originally thought this problem was with my report so I posted it under the reports section but not I'm seeing that it is a query problem so I am re- posting it here. I ran in to some problems while trying to do a sum in my report footer but had ...

Message posted on the April 20th, 2010 - 11:14 AM ET

Pass through query how to run in VB code.

Hi I have a pass through query that i have defined in access, and works fine. How do you run it in code? I get the error 'Cannot execute a select query.' Set db = OpenDatabase(sdb) With db sSQL = db.QueryDefs(qry).SQL If db.QueryDefs(qry).Type = ...

Message posted on the May 18th, 2009 - 9:42 PM ET

ADODB from Excel - Running a Query

I have the following code linked to a button on a worksheet in Excel. I am trying to run two existing queries in my Access database. The first is a "make table" query that creates a table and loads data into it from another table in the ...

Message posted on the November 9th, 2009 - 12:16 PM ET

INSERT INTO from query

Hello The following statement works: CurrentDb.Execute ("INSERT INTO tblPayments (salesconsultantid) SELECT salesconsultantid FROM tblContracts"), dbFailOnError But when I change tblContracts to qryWeeklystatementsbase: ...

Message posted on the December 25th, 2010 - 11:27 AM ET

Passing a variable from one SQL execute task to another SQL exec t

Hi - I have an SSIS package with two Execute SQL tasks. The first task when runs needs to get max value from a table. Here is the query SELECT MAX(ID) from Table1. I want to store the result of this query into a variable which I want to use into ...

Message posted on the January 25th, 2010 - 4:38 PM ET

New Query Design in Access 2007 MDE

Does anyone know how to open the standard Access 2007 new query design in a compiled .mde or .accde? My advanced customers sometimes need the capability to create queries themselves. In Access 2003 and prior, the standard RunCommand worked fine. ...

Message posted on the June 1st, 2009 - 5:55 PM ET

Option Group Value won't display in Query when code is executed

Hello, I have an option group stored on a form with 4 choices and am just trying to usethe value selected in the option group within a query. Simple enough, I can get the query to work just fine, displaying information based on the choice made ...

Message posted on the December 11th, 2009 - 4:27 PM ET

When working in Query Analyzer, what can I use in order to bring up a dialog box?

I am testing query in SQL express and when I execute the query I what a dialog box to pop up so I can input the Start date and End date. When working in Query Analyzer, what can I use in order to bring up a dialog box? For example, this query ...

Message posted on the October 2nd, 2009 - 7:21 PM ET

Unable to set query parameter

I'm having problem setting a parameter in an append query. I want to optionally use all records or only active records (Inactive field = False). In the Inactive field of the query, I have this: 0 or [blnIncludeInactives] If I want to use all ...

Message posted on the March 9th, 2009 - 2:47 PM ET

sp_send_dbmail fails when using @query

I am running Window Server R2 EEx64 SP2 and Sql Server 2005 SP2 I have many other hosts with the same service pack levels and I use the same domain account for all the mail profiles. I can run the sp_send_dbmail with the @query specified on the ...

Message posted on the February 6th, 2009 - 11:36 PM ET

Error Exporting Access Query Results to Excel

I'm having 2 different problems exporting query results from Access to Excel (Office 2007). Problem 1: I do what I've always done, in Access VBA get ADO recordset from query results, instantiate Excel, get a range object, use the range object's ...

Message posted on the May 4th, 2010 - 6:46 PM ET

The query execution taking too long

Hello, My server machine details are (2 x 2.26 GHZ Quad Core Processor, 12 GB RAM, SQL Server 2005 Enterprise Edition, 500 GB SATA HDD) I am using the following query to execute in SQL 2005 Server, SET @sqlString = 'INSERT INTO [VoucherDetail' + ...

Message posted on the September 8th, 2009 - 5:11 AM ET