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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Joining Several results together in one table
I have the following table. File Type Date Opened ------------- --------------- jpg 01-03-2010 gif 01-02-2010 png 18-02-2010 png 06-01-2010 jpg 02-03-2010 gif 25-02-2010 gif 30-01-2010 png... -
Multiple Count queries within Insert statement
Hello, I am trying to construct an sql statement that will insert a new row in to the frequency table containing the ball number, count statement to count how many times a particular ball has been drawn as a main ball, count statement to count how many times a particular ball has been draw as...- Andy722
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
