|
|
# 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. ...
|
|
1 |
121 |
|
|
|
|
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...
|
|
1 |
87 |
|
|
|
|
0 |
127 |
|
|
|
|
1 |
112 |
|
|
###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...
|
|
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
|
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...
|
|
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
|
2 |
105 |
|
|
|
|
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...
|
|
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...
|
|
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...
|
|
1 |
184 |
|
|
#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). ...
|
|
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()
( 1 2)
|
|
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
|
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...
|
|
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...
|
|
1 |
112 |
|
|
#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...
|
|
2 |
816 |
|
|
|
|
1 |
118 |