|
|
Zip Code/Market Area by
Jason Spence
I have a table of several hundred customers and I want to
run a query/report that shows me in what DMA Market these
people are in. I have a list that I can...
|
|
3 |
184 |
|
|
zip code with x miles of another zip code by
Stephanie
Hi, there. My db lists Members with their city, state and zip. Often a Member
will call the office and ask if there are other Members near them. If the...
|
|
2 |
68 |
|
|
zip code range issue by
THE BIG O
Hello,
I was provided a table (XXXXZipCodeSvc) from another party that lists zip
range low and zip range high and a code for each range.
example
zip...
|
|
2 |
55 |
|
|
|
|
2 |
93 |
|
|
Zip code query with 5 and 9 digit zip codes by
andie36
Hi,
I have a table called List and a table called Zips. I want to pull
customers from the List table, and assign them a region based on the
information in the...
|
August 9th, 2005 06:57 PM
by Chaim
|
3 |
83 |
|
|
Zip Code Query by
Kevin D.
I want to do a query based on zip codes but want the query to only consider
the first 5 numbers of the zip code, so if a zip code is entered as
12345-6789,...
|
|
2 |
99 |
|
|
Zip Code Query by
Mike
I am working with two tables. Each table contains a field for a zip code.
Table A has an 11 digit zip code and Table B has an 11 digit zip code. I
currently...
|
|
2 |
74 |
|
|
Zip Code Lookup by
jrcigar
I am trying to look up a territory for a given zip code. Can someone please
help?
I have one table with a list of about 10,000 stores including their...
|
December 17th, 2008 07:22 AM
by tina
|
3 |
87 |
|
|
Zip Code Count by
Glenn Dulmage
I want to make a count of 5 Zip codes from a small database of about 3,000 records.
How do I do this (i.e. what sort of query, what grouping and...
|
|
6 |
95 |
|
|
Zeros to replace nulls in Crosstab by
Paul Ilacqua
Is it possible to replace nulls with zero's in a crosstab's value field
IIF(IsNull(XXX),0,XXX) does not seem to work. Please help if possible.
Thanks in...
|
|
3 |
110 |
|
|
Zeros in a crosstab query by
Jim Jones
I have a crosstab query which analyses examination results. For a given
subject, the query counts the number of students with each grade (A, B, C,
etc) (the...
|
|
3 |
76 |
|
|
zero's in a query by
Melinda
In a query I am calculating dates, in five different intervals, Expr1:
-NZ(,Date())+1, i have 5 different expressions and then I am
adding and subtracting...
|
January 2nd, 2007 08:29 PM
by Melinda
|
5 |
73 |
|
|
Zero values in query by
jk
Hello,
My query runs great but i have zero values appear in some coulmns.How do you
remove the zeros?
Thanks
|
|
3 |
139 |
|
|
zero values by
Claudia
My query is meant to show only sales in 2006 but the report generates a
listing for a customer even if there are no '06 sales (ie there were sales
in...
|
February 14th, 2006 09:41 PM
by Claudia
|
5 |
77 |
|
|
|
|
3 |
129 |
|
|
zero sums by
SoLah
I'm confused about the Is Null feature in queries.
I have a query that sums 25 values, val1, val2,val3.... From that i print
out a bar chart in a report that...
|
|
2 |
66 |
|
|
Zero returned as results by
jboon
When I view the datasheet view of my make table query, the data is calculated
as expected. However, when I run the make table query and open the table...
|
|
1 |
62 |
|
|
Zero length String? by
Bongard
Hi, I have a TEXT field in my query whose criteria is a Function
NodeFilter(). This function looks to a form that allows the user to
fill in data and then runs...
|
|
1 |
114 |
|
|
Zero Length Join by
mcgj
How do I create a query that uses multiple fields to do the linking between
tables when sometimes some of the values in one or two of the fields have
zero...
|
|
1 |
65 |
|
|
Zero instead of null in query by
Lori2836 via AccessMonster.com
Good morning. I would like the Uncosted Qty and Uncosted Value to show up
as zeros, when this query is run, instead of nothing. I'm pretty sure I
need to...
|
|
2 |
191 |