I have a field in a MS Access report that I need to do the following:
=[AdCost]/[AvgCalls]
In some cases [AvgCalls] value is 0 so I get the error "#Div/0!". I would like to this value to be ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20280542.html
I can try to write an IFF statement in the table default value. I would like the FY value to return current year if current date is before October 1, else FY = next year.
Please advice. Thanks.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20881616.html
Zones:
MS AccessDate Answered: 04/08/2004 Grade: A Views: 0
Hi guys:
I need the syntax of iff statement in C# (if there is one) . thanks
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21175707.html
Zones:
C#Date Answered: 10/20/2004 Grade: A Views: 69
have this in a querry
EIWeighting: 100/[TotalWeighting]*[TET]
returns the right results falls over a lilttle if TET is 0
so did this in the querry
EIWeighting: IFF([TET]=0,0(100/[To...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21669182.html
Zones:
MS AccessDate Answered: 12/29/2005 Grade: A Views: 0
hi experts,
hope you're all having as much fun as I am coding today :D
(man do i hate web coding)
anyway, i am trying to force a checkbox to be checked or not inside a Repeater control with ...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_22086024.html
hi i have two fields i need to do a calculation on
I have a field called "Event" and "Cost"
Example:
Event | Cost
------------------
CostP 200
SoldP 300
i want to say where al...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_22134996.html
Zones:
Visual BasicDate Answered: 01/26/2007 Grade: A Views: 5
I want to use IIF statement equivalient in C# coding
if strName is Empty I want to pass System.DBnull.value to be inserted in DB else strName would be passed
string strName;
strName = TxtName....
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_CSharp/Q_22757145.html
I have a query that gives me the following results:
BegHours EndingHours TotalTimeRun
36.2 36.7 30 Min...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10235865.html
Zones:
MS AccessDate Answered: 11/19/1999 Grade: A Views: 6
I have a query with the criteria of "[forms]![frmReportsMenu0].[TextLastName]". If the user types a last name into the field "TextLastName" I want the query to return the records with the value fr...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20604224.html
Zones:
MS AccessDate Answered: 05/02/2003 Grade: A Views: 14
Hi experts,
I am doing a calcualtion on
SQL statement, but one of the columns is 0 that I am dividing something by so I am usinbg
col1/col2.... oif col 2 is 0 then I have a problem, how can...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21240649.html
Zones:
MS SQL ServerDate Answered: 01/15/2005 Grade: A Views: 260
