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 and currency issues by Dos Equis
I am building a qeury to identify how much each carrier is paid. I have all the elements available but not sure how to proceed from here. Each carrier is...
November 9th, 2006 10:59 PM
by Jeff L Go to last post
1 96
#Error for CountOf by [email protected]
My function in my report : "=Sum(", which works whenever a query contains records, returns the following when a query contains no records: "#Error" When I...
May 1st, 2007 09:46 PM
by [email protected] Go to last post
2 89
#Error Help Needed by mattc66 via AccessMonster.com
Need help. The End_Date field is bland and if so formating it returned a #ERROR in the field when I run a query. I thought I could do an IIF(IsError(.. . to...
January 30th, 2008 06:09 PM
by Duane Hookom Go to last post
2 135
#error in access query by PatT123
I have a join that leaves null values, and is supposed to in a query result. Only supervisors have a supervisor code. Employees do not. I am trying...
January 24th, 2007 08:57 PM
by PatT123 Go to last post
0 235
#Error in calculated field by Marianne
I have a union query: SELECT Service_Plan_ID, Format(Start_Time,"h:mm") as Start, Format(End_Time,"h:mm") as End, ServDate, InvNo, Recnum, "" as Qty, "" as...
November 21st, 2008 04:39 AM
by Allen Browne Go to last post
3 175
#ERROR in calculated field by juan
hi, I have the following expression in a field: ACP: Format(/,"0.00000") works fine but as you know if try to divide 0/0 will get the #ERROR. Is there a way...
October 20th, 2004 10:35 PM
by Juan Go to last post
2 108
#Error in calculated field of Datasheet view of query by DocBrown
I have the following query (stripped down to highlight the error): SELECT Volunteers.VolunteerID, Volunteers.CommitHours, Int(CSng(Sum(-)*24)) & ":" &...
June 12th, 2008 08:12 AM
by DocBrown Go to last post
2 138
#Error in custom function by Kirk P.
I've got this function that returns good results except for some records return #Error. This #Error is expected, and I'm trying to trap it and report the...
August 14th, 2006 08:05 PM
by jmonty Go to last post
1 89
#Error in date field by Kushum
Hi everyone, I would be grateful if someone could tell me how to handle errors in queries. The problem is that I am using DateAdd function to add up a...
September 25th, 2005 12:07 AM
by Kushum Go to last post
2 157
#Error in Query by mattc66 via AccessMonster.com
I have the following in my query and it keeps returning a #Error. Can anyone tell me what I am doing wrong? IIf(IsError(/),0,/) Matt --
August 21st, 2008 06:49 PM
by ANDY-N via AccessMonster.com Go to last post
1 163
#Error in query by rookie
I created an IIf statement in my query and it somewhat works. When I ran it, the "False" showed up as "False". However, the "True" showed up as "#Error". Why...
November 5th, 2009 02:40 AM
by Dale Fye Go to last post
5 154
#Error in Query by Varun Nair
Hi, I am using the following code in a query and i am getting #Error when i run the query and because of this i am not able to export to Excel. Please help me...
February 18th, 2006 03:40 PM
by Varun Nair Go to last post
5 103
#Error in query by Carlos
Hello, I have a table R, ID as number T as text | ID | T | | 1 | A01 | | 2 | CEE |
June 2nd, 2006 12:38 AM
by John W. Vinson/MVP Go to last post
1 76
#Error in Query - but not a div by 0 - so what is it? by Katie Scott
Hello to all, I am puzzling over a problem I'm having with a query that used to work and now gives me a #Error. Even when I simplify it - it is a problem...
March 7th, 2009 06:08 PM
by Katie Scott[_2_] Go to last post
2 92
#Error In Query Problem by Paputxi
I have a query where in one column I have a calculation that is suppose to return a "G", "Y", or "R". However, due to non-existing values for some instances...
March 29th, 2007 08:40 PM
by John Spencer Go to last post
1 117
#Error in Query result by James
I have a calculation in a query that gives #Error in some of the results. Calculation is as follows: ((*(1+/365))^) The error does not occur when I drop the...
June 16th, 2005 11:39 AM
by Michel Walsh Go to last post
1 117
#Error in Results by Coach K
I have a query that calculates dates using the WorkingDays2 function. If one of the fields does not have a date yet i get the #error in the record. What do i...
February 11th, 2009 10:58 PM
by Douglas J. Steele[_3_] Go to last post
5 132
#Error in select query by Aivars
Hello, I am getting #Error in VAL field when I do very simple query based on qryKS3 query: SELECT * FROM qryKS3 WHERE round(,2)=0.01 here is qryKS3:
November 18th, 2006 08:25 PM
by Aivars Go to last post
6 142
#Error in SELECT query with OUTER JOIN by Wesley Wildman
Context: Access 2003, MDB file Setup: I have a query defined (schematically) as "SubqueryA LEFT JOIN SubqueryB". The query returns some rows from SubqueryA...
December 6th, 2006 05:06 AM
by Wesley Wildman Go to last post
4 119
#Error Message by TiffyMilly
I have been working on a database that calculates the cost/usage of the peridocials by dviding the cost by the usage. If the value of the usage is 0, then the...
March 15th, 2005 03:52 PM
by Allen Browne Go to last post
3 105
Post New Thread


Display Options
Showing threads 81 to 100 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 02:43 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.