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
# of days since Jan. 1 by mate
i want to use the number of days since Jan. 1 first in an equation. Is there an expression to calculate this? any help is greatly appreciated. ...
July 18th, 2004 11:57 PM
by John Vinson Go to last post
1 121
# of working days between receipt & complete by CaribbeanBlue
I'm a newbie trying to create the # of working days either in a query or via a report between the date something was received & the date we finished it. ...
March 2nd, 2007 03:49 PM
by CaribbeanBlue Go to last post
0 106
## conditional expression by Justine
I wrote the following IIF statemeent: url: IIf(IsNull(), & ,) domainname is a text field with http://www.something.com link simply shows...
September 14th, 2006 09:02 PM
by Marshall Barton Go to last post
1 87
## Rabbi caught on tape with 17 stripper hidden video by [email protected]
Right here http://rabbishare.blogspot.com/2009/01/rcmp-obstructed-paramedics-firefighter.html - Hidden video of Rabbi having sex with 17 year old stripper...
January 28th, 2009 08:52 AM
by [email protected] Go to last post
0 127
#####Using Control as a Query parameter##### by Jimmy
Hi folks, I'm have a query set up which retrieves data from a batchArchive table and restores it to the 'main' Batch table. The dates are selected using...
November 24th, 2004 06:53 PM
by John Vinson Go to last post
1 110
###Divide in a select query### by Jimmy
Hi folks, This may be a simple one so forgive my lack of knowledge... I have a field named , what I want to do is create a query to divide the sum of all...
December 1st, 2004 05:27 PM
by Ted Allen Go to last post
2 124
#Delete returned in field by AlanC
I am running Access 2003 with a SQLServer 2005 backend to store the data. When performing certain queries with a left join between tables/queries and the...
July 4th, 2007 01:34 PM
by AlanC Go to last post
0 98
#DELETED by Stewart Saathoff
Hello, I need some assistance. I have a form in access 2003 that is linked to a SQL 2000 Database. I get a #DELETED Message on the form, but the records are...
August 27th, 2004 12:02 PM
by Van T. Dinh Go to last post
1 143
#deleted on linked table select query by Mark
I'm doing a select query on linked tables where the source data is in an AS400 database. It's a left outer join query (tableA left outer join tableB on...
August 27th, 2008 08:51 PM
by Mark Go to last post
2 105
#Deleted returned by query against linked SQL tables by Dale Fye
The following query: SELECT U.User_ID, U.Org, NZ(GV.Gap_Likelihood, 0) as Gap_Likelihood, NZ(GV.Gap_Impact, 0) as Gap_Impact FROM...
August 7th, 2008 09:25 PM
by Dirtbike Go to last post
8 210
#Error by SHIPP
I have a right join in a query. When there isn't any join on the right side I want a zero placed in the column. I am using Access 2003. I have tried the...
July 12th, 2007 03:30 PM
by Ofer Cohen Go to last post
1 82
#Error by SJW_OST[_2_]
I am using the following formula in my Query. Correct: Left$(,InStrRev(,"_")-1) I am using this formula to convert some data to the...
May 29th, 2008 08:52 PM
by S.Clark[_2_] Go to last post
5 101
#Error by FBxiii
Hi, I have a query that combines several other queries with Left joins. The 'main' query has a field called LDZ, this relates to the other queries and forms...
November 16th, 2004 03:13 PM
by [MVP] S.Clark Go to last post
1 182
#error by Jaybird
Howdy folks! I've got a query expression that is giving me a #error when the field does not contain "A". It goes like this: Age: Mid(,InStr(,"A"),1). ...
May 23rd, 2007 05:58 PM
by Jaybird Go to last post
2 89
#ERROR by Boz
I am trying to calculate elapsed time. The first field in the query: Arrival Date/Time 99/99/0000\ 00:00;;_ The second field in the query: Now:Now()
(Multi-page thread 1 2)
November 13th, 2006 01:28 PM
by John Spencer Go to last post
10 138
#Error by LJG
Hi Guys, Any suggestions why I am getting the #error with this Margin: Nz(,0)/Nz(,0)/100 This happens if the field discount has a value of 0
July 30th, 2006 09:44 PM
by fredg Go to last post
1 133
#Error by Gary
I am using Access 2003 I have a field called ProductName. The kinds of products available - appear in the following examples: AB1000 AB900 AB1000 ST The...
July 2nd, 2006 01:13 PM
by Duane Hookom Go to last post
2 101
#Error by TiffyMilly
I am working on a perodicals database that holds usage statistics. I am using the following code to calculate the cost per use, by dividing the cost by the...
March 18th, 2005 12:19 AM
by John Spencer (MVP) Go to last post
1 110
#Error by CAM[_2_]
Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields...
May 22nd, 2010 03:35 AM
by CAM[_2_] Go to last post
2 750
#Error - possible Reference Library omission? by JASelep
I'm comparing MyGroup with the few in RtrnNotice to identify who (in MyGroup) still needs to "return Notice" I've tried the below several ways but if there is...
October 11th, 2007 02:20 AM
by Allen Browne Go to last post
1 118
Post New Thread


Display Options
Showing threads 61 to 80 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 12:53 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.