By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,482 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

access sql

100+
P: 158
Easy question. I'm using access 2003 and i'm trying to get my query to ask the user which territory they want to use. Here is my code that i have so far that lists all the territories and their corresponding information.

Expand|Select|Wrap|Line Numbers
  1. SELECT MasterZip.Territory, Count(MasterZip.[ZIP Code]) AS [CountOfZIP Code], Sum(MasterZip.MVRs) AS SumOfMVRs, Sum(MasterZip.Outlets) AS SumOfOutlets
  2. FROM MasterZip
  3. GROUP BY MasterZip.Territory;
All i need the code to do is have the popup saying it needs a specific territory to filter the query by. Hopefully this is not too confusing.

Thanks for any input
Matt
Aug 13 '08 #1
Share this Question
Share on Google+
2 Replies


100+
P: 158
ok never mind i figured it out....one of those days lol
Aug 13 '08 #2

10K+
P: 13,264
ok never mind i figured it out....one of those days lol
I'll move it to the Access forum anyway.
Aug 14 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.