J
Jamie Collins
Sorry I've been away so long, people, but I've been immersed in Web
2.0. These newsgroup posts take too long to open and read, so here's
some quick-fire answers based on the titles alone:
Q. similar situation
A. Rock and a hard place.
Q. Insert Query to a Table
A. INSERT INTO a VALUES ('Query');
Q. Query Quandry
A. SELECT * FROM Quandry;
Q. Promt query
A. SELECT 0;
Q. confusing queries
A. These (legal Jet SQL syntax) will likely confuse most people:
CREATE TABLE [DATE] ([DATE] DATE);
SELECT DATE (SELECT DATE FROM [DATE]) FROM [DATE];
Q. Group by Weeks of the Month
A. SELECT Weeks FROM [the Month] GROUP BY Weeks;
Q. Results multiplied by 3??
A.
SELECT * FROM YourTable
UNION ALL
SELECT * FROM YourTable
UNION ALL
SELECT * FROM YourTable;
Q. Not Like Operator
A. Try redialling; you'll likely get a different Operator next time.
Q. Append Query - How?
A. You just did!
Q. Summarize Data
A. A collection of natural phenomena.
2.0. These newsgroup posts take too long to open and read, so here's
some quick-fire answers based on the titles alone:
Q. similar situation
A. Rock and a hard place.
Q. Insert Query to a Table
A. INSERT INTO a VALUES ('Query');
Q. Query Quandry
A. SELECT * FROM Quandry;
Q. Promt query
A. SELECT 0;
Q. confusing queries
A. These (legal Jet SQL syntax) will likely confuse most people:
CREATE TABLE [DATE] ([DATE] DATE);
SELECT DATE (SELECT DATE FROM [DATE]) FROM [DATE];
Q. Group by Weeks of the Month
A. SELECT Weeks FROM [the Month] GROUP BY Weeks;
Q. Results multiplied by 3??
A.
SELECT * FROM YourTable
UNION ALL
SELECT * FROM YourTable
UNION ALL
SELECT * FROM YourTable;
Q. Not Like Operator
A. Try redialling; you'll likely get a different Operator next time.
Q. Append Query - How?
A. You just did!
Q. Summarize Data
A. A collection of natural phenomena.