Advertisement

1 - 10 of 481 containing alltags:("iif") (0.001 seconds)
I am using a query as a recordsource for the report. The report opens a form (dialog box) where you specify the criteria to run the report. I am using beg and end date - they work fine as the crite...
Zones: MS AccessDate Answered: 07/26/1999 Grade: A Views: 0
Hi   When I compile the follwing code I get an error   cannot resolve symbol   method iif (boolean)    for( int i = 0; iif( afr.charAt(i) == '/'); i++)                afr.setCharAt(i,...
Zones: JavaDate Answered: 07/17/2001 Grade: A Views: 0
Field is a currency field, the result of a Sum query, called CMTotal, representing the sum of Credit Memos received against a particular transaction. Works fine on a report, except when there are n...
Zones: MS AccessDate Answered: 02/07/2002 Grade: A Views: 0
I would like to get all of the values from a table(3compdet) where Field (company id) = the value of a combo box on the form ([Forms]![competition3]![competitor1]).  If I use the dlookup like below...
Zones: MS AccessDate Answered: 04/15/2002 Grade: A Views: 0
Hey everyone, i have the following sub routine and when i open the datareader and and try to assing the values i am getting this error "Object reference not set to an instance of an object"  here i...
Zones: .NETDate Answered: 11/21/2002 Grade: A Views: 0
Please, go and have a look here and give me your best shot: http://www.experts-exchange.com/Databases/MS_Access/Q_20412509.html Thanks guys (and girls)
Zones: MS AccessDate Answered: 01/13/2003 Grade: B Views: 0
I have a list box named List_Available with its source a query. This query depends on whats in Selected in two combo boxes, Combo_Category and Combo_Type. Right now the results only show if both Co...
Zones: MS AccessDate Answered: 02/09/2004 Grade: B Views: 0
Greetings Experts, My CFXM is way too rusty.  In access i can easily manipulate the data with a few queries.  Here's my attempt at doing this in Coldfusion. Please Note my Comments, they sort the...
Zones: ColdFusion Application ServerDate Answered: 08/24/2004 Grade: A Views: 0
I have yet another crosstab query question.  I need a crosstab that will display how many of two products, ("SAH" & "Refinance") had a close date (calculated by [PhaseDt]-[AppDt]) in less than 20 d...
Zones: MS AccessDate Answered: 05/30/2005 Grade: A Views: 0
Hey guys I am trying to do a db for my ebay transactions - to see if I actually am making any money on stuff with ebay fees and what have you. My problem lies with the ebay fees - as these wi...
Zones: DatabasesDate Answered: 04/22/2005 Grade: A Views: 0