Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pendragons10
- Order by date
-
Error message in update-subquery
UPDATE Queries Dont like more than 1 WHERE statement - try HAVING.... or put both WHERE criteria together using AND.- pendragons10
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Updating tables
use INSERT.....INTO or an APPEND QUERY- pendragons10
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Top 5 Query Customization Question
Try SELECT [TOP n [PERCENT] FROM table Short but Sweet Best of luck!- pendragons10
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Can I run an SQL 7 Stored proceedure from Access 2000?
Im afraid the simple answer is ....NO! The Jet engine does not recognise this statement!!!- pendragons10
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Is Failure of JET SQL/Access Possible?
The answer from experience is absolutely, Jet can take exception to the strangest things (Especially anything not originally invented and owned by MS like......SQL!!!) Sorry - not much help, but very sympathetic!- pendragons10
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Selecting the first or last record in a one to many relationship
If you include MAX(date) or MIN(date) will return the Last or First Date if dates are chronological.- pendragons10
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Rows -> Columns CrossTab, PivotTable??
Good explanation of crosstab SQL using TRANSFORM statement at http://www.cse.bris.ac.uk/~ccmjs/acc97-r5.htm#ex16- pendragons10
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Count of records by location monthly
Use an aggregate query, I'm not sure exactly what information your looking for or if its in the same table or not but use a modification of SELECT COUNT(NumberEntries) AS Total, Location, DATEPART(m, SQL_date) AS MONTH From Table1 GROUP BY Location, SQL_date. Or the function MONTH(SQL_date) is...- pendragons10
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Query for Reciprocating Data Fields
I'm not sure if this will deliver but It looks very similar - Access provides a crosstab query which works like a pivot table chech out the TRANSFORM statement. You'll find a good explanation at http://www.bris.ac.uk/is/services/software/packages/access/#introdoc Best of luck!- pendragons10
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
