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
#Error on IIF Statement by RaeRae
I have a query that I need to have return a calculation for me. I'm not sure why I'm getting this error. Can someone help? My fields have a Quantity, Unit...
January 4th, 2007 10:16 AM
by Jamie Collins Go to last post
2 109
#ERROR question by Elmtree via AccessMonster.com
My formula: Mid(,InStr(10,,": ")-1) returns #ERROR if the value is blank, otherwise works fine. Any ideas how to change my formula to get beyond the...
June 19th, 2009 08:41 PM
by John Spencer MVP Go to last post
2 190
#ERROR question by Elmtree via AccessMonster.com
My formula: Mid(,InStr(10,,": ")-1) returns #ERROR if the value is blank, otherwise works fine. Any ideas how to change my formula to get beyond the...
June 19th, 2009 08:43 PM
by Jerry Whittle Go to last post
2 128
#Error Results in Query by Sherry N.
Hello, I expect my query to return some #Error results b/c there is division involved with 0. What I would like to do is create some kind of statement in the...
September 1st, 2005 08:42 PM
by Ofer Go to last post
2 129
#error results in unmatched records of outer join by Steve
Doing a simple query where I join a master table with all records and a query that creates a subset of data. When I look at the result set after the join, the...
June 10th, 2006 04:24 PM
by strive4peace Go to last post
9 110
#Error using Iif(x,0,Trim(Right([NettingGrp],20)) by ragtopcaddy via AccessMonster.com
I get a #error returned if the following Iif statement is false: Netting_Group: IIf(Trim()=0,0,Trim(Right(,20))) Meanwhile, the following statement returns...
July 28th, 2006 01:05 PM
by ragtopcaddy via AccessMonster.com Go to last post
6 94
#Error using sub query by Paul Dennis
I have 2 tables, one is the main data tables and another an audit table, hence unless an activity has taken plan will not contain related records to the main...
December 1st, 2005 06:45 PM
by Paul Dennis Go to last post
0 108
#Error when referencing "," in query formula by bandblue
Hello, I have a query that I am pulling out selective data from a string of a part description. Here is the part description. RESISTOR 0603 47KOHM,5% Note...
October 20th, 2005 07:12 AM
by bandblue Go to last post
2 106
#Error when using IIF statement in a query by [email protected]
Hi, I am trying to create a query that has one of the fields, instead of being linked to a table, calculating a margin based on the value in a field, . The...
(Multi-page thread 1 2)
November 9th, 2006 08:43 PM
by [email protected] Go to last post
11 154
#Error when using Left Function by Melinda
Hello, I am trying to query out all but the last 3 characters of my contract name. Here's the SQL I'm using: SELECT Left(,Len(-3)) AS JobCode FROM...
January 14th, 2005 02:15 PM
by Melinda Go to last post
6 208
#Error when using stDev in query by [email protected]
I am getting an error when running a query with StDev in Access. Most rows have a good calc value, but 2 rows have an #Error value. When I try to sort by the...
May 7th, 2007 07:36 PM
by Michel Walsh Go to last post
1 125
#Name error in Query by BBC
Have read at least 100 posts re #name errors and still can't figure out what's wrong with mine. I have a master form (and table, both called "Client") that has...
(Multi-page thread 1 2 3)
February 13th, 2009 07:27 PM
by BBC via AccessMonster.com Go to last post
25 319
#Name? by Thrinky
Hello, I am trying to write a query that will provide me with any results that are outside the range of 6.0 - 28.0. The result field is 'Text' and contain...
April 21st, 2005 03:39 PM
by Thrinky Go to last post
2 90
#Name? by Novice2000
Hi, I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I...
June 26th, 2007 04:27 PM
by Novice2000 Go to last post
3 101
#name? by datahunter
I have a querie which i get a final total but when i try to set my querie as the record source for my report or a textbox in my form, when i try to run my...
September 15th, 2007 03:39 AM
by Allen Browne Go to last post
1 96
#NAME? Error on Form by Rob B.[_2_]
I want some form fields to automatically populate with data once another field on the form is filled in. Specifically, I want a city and state to fill in...
July 23rd, 2007 12:09 PM
by BruceM[_2_] Go to last post
2 74
#Name? errors when using query as data source for form by Chris Burnette
I have a simple query that retrieves a few fields from an MSDE database that is connected via linked tables. When I run this query in datasheet view, it works...
October 17th, 2005 03:43 PM
by Brendan Reynolds Go to last post
4 105
#Name? in text box with unique name by Richard Hollenbeck
I think it is the GROUP BY not being equal to anything. I want totals of all grades from each student. I don't know what to make studentID equal...
October 2nd, 2004 10:38 AM
by Richard Hollenbeck Go to last post
2 106
#NAME? problem by Lisa
I have 2 tables with a relationship and enforced referential integrity selected. When I use the Query in QBE or in a Form or Report it is hit and miss. ...
December 2nd, 2004 04:09 PM
by Lisa Go to last post
2 104
#Name? What does this mean? by Novice2000
Seen this out here before, but I have never seen an answer. What is this. I have entered all of the criteria for a query, and it opens up, but when I...
October 3rd, 2007 01:53 AM
by Jerry Whittle Go to last post
5 113
Post New Thread


Display Options
Showing threads 101 to 120 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 10:24 PM.


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