|
I am completely new to Microsoft Query.
I have the following tables defined:
FLEET_MASTERS Table - REG_NO - FMS_ID ODOMETERS Table - ODO_ID - FMS_ID ODOMETERS_READING Table - ODO_ID - ODO_READING - ODO_READING_DATE - ODO_READING_TYPE
I need these information...
Started by khoa on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The following query would give you what you want, assuming there's only one record per Reg_No for a given date.
|
|
Hi, I want to be able to insert parameters into queries which are not able to be represented graphically in Microsoft Query. At the moment I am doing this by creating a simple query and then using the External Data Properties -->Connection Properties...
Started by SafariV8 on
, 11 posts
by 3 people.
Answer Snippets (Read the full thread at microsoft):
I'd of the query wizard....
Gt; From Microsoft Query process, I still end up in MS Query :-( Should my question have been "HowThen I guess you have your answer: it can't be done without first defining a simpler query.
|
|
End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering that MS Query lists all objects from all schemas, regardless...
Started by Ed Leighton-Dick on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Microsoft Query does a call to [database].sys.sp_tables which in turn.
No, not that I've ever found.
|
Ask your Facebook Friends
|
Can someone please help me out with a query? In Microsoft SQL Server, I have the following query, which executes fine:
SELECT * FROM ControlPoint INNER JOIN Project ON ControlPoint.ProjectID = Project.ProjectID INNER JOIN Site ON Site.SiteID = Project...
Started by icemanind on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The syntax error is caused because.
In the Access query window and with DAO, percent is used with ADO.
|
|
So I have learned a bit about databases and Microsoft Access specifically, trying to help maintain a Microsoft Office Access 2003 database with Visual Basic scripting (version 6.5) which was set up by several people who are no longer with the company....
Answer Snippets (Read the full thread at stackoverflow):
If the query is in the current.
A reference to an Access mde or mdb? Does the code create the query and then delete the query, you can search for the two queries by name in the code, and see what it turns up.
|
|
I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program.
The Microsoft Access database comes from a third-party; I am only reading the data.
I have generally been having success in extracting ...
Started by Oddthinking on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
PYODBC starts with autocommit = False and therefore every ....
I guess the problem may be that you did not commit the query.
You have the same problem with other ODBC tools, for example Query Tool ? You can also turn on ODBC corruption.
|
|
On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better way. All the tables involved have a primary key. Here...
Started by Knox on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For some://support.microsoft.com/default....
Seriously consider switching to a more capable SQL product.
I'm afraid you're out of luck without an updatable query" are very painful.
The Jet query optimizer treats it the same way it treats a join.
|
|
I have a (very simple and standard) UPDATE statement which works fine either directly in Query Analyser, or executed as a stored procedure in Query Analyser.
UPDATE A SET A.field1 = B.col1 , A.field2 = B.col2 FROM tblA AS A INNER JOIN tblB AS B ON A.pk...
Started by joedotnot on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://....
Before you start the trace associated with when the fail .
Also, I think you when you execute from access?
Run the query with SQL PRofiler running.
Try and see whether the query gets executed on the SQL Server using SQL profiler.
|
|
I have basically the same problem outlined in this question, however I am using Microsoft Access as a database instead of MySQL. The result of which is that SQL_CALC_FOUND_ROWS doesn't seem to be available to me. Believe me, I want to switch, but for ...
Started by dbingham on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Still, it should be faster than executing the query twice..
Read all the records.
|
|
I'd like to rewrite this query for Microsoft Access 2003:
SELECT t1.PERSONID ,t1.CARDEVENTDATE ,MIN(t1.CARDEVENTTIME1) AS Intime ,MAX(t2.CARDEVENTTIME1) AS Outtime FROM ( SELECT PERSONID , CARDEVENTDATE , FUNCTIONKEY , CONVERT(VARCHAR(10), SUBSTRING(CARDEVENTTIME...
Started by Gopal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Can you not use the normal Access function Str(...) ?
Update: Dont have Access here to try it, but isn't there a parameter which tells Access to just use the sql as pass throught (without modifying it) ?
The sample below may suit, if you use SQL Server... .
|
