A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
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...
June 8th, 2004 11:49 PM
by John Vinson Go to last post
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...
January 8th, 2008 01:03 AM
by Gina Whipp Go to last post
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...
July 25th, 2007 05:16 PM
by John W. Vinson Go to last post
2 55
Zip Code Radius lookup using Access and ASP by [email protected]
Hello, We’ve been having a hard time using ASP to query a MS Access database for zip code proximity information. There doesn’t seem to be any code...
April 13th, 2006 08:26 PM
by [email protected] Go to last post
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 Go to last post
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,...
April 30th, 2007 01:16 PM
by John Spencer Go to last post
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...
November 27th, 2007 04:33 PM
by Michel Walsh Go to last post
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 Go to last post
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...
October 9th, 2005 08:41 PM
by Glenn Dulmage Go to last post
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...
November 23rd, 2004 02:45 AM
by John Spencer (MVP) Go to last post
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...
February 25th, 2005 05:07 PM
by Duane Hookom Go to last post
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 Go to last post
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
September 23rd, 2004 01:52 PM
by Duane Hookom Go to last post
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 Go to last post
5 77
Zero value for queries that bring back no results by ChuckW
Hi, I am running a series of queries that measure weekly sales for various products. Some of them do not have any sales for the week and bring back...
November 23rd, 2005 05:45 PM
by Allen Browne Go to last post
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...
April 6th, 2006 06:51 PM
by Jeff Boyce Go to last post
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...
March 23rd, 2007 05:22 AM
by Allen Browne Go to last post
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...
January 29th, 2008 07:14 PM
by BruceM[_2_] Go to last post
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...
November 16th, 2005 06:11 PM
by Sylvain Lafontaine Go to last post
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...
August 19th, 2009 04:02 PM
by Lori2836 via AccessMonster.com Go to last post
2 191
Post New Thread


Display Options
Showing threads 41 to 60 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.