Enter Keywords:
1 - 10 of 508(0.001 seconds)
Sort By:
 
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 Rating: 8.6 Views: 0
I have an Access SQL query I'd like to convert to a stored procedure in SQL Server 7.  I'm pretty sure it requires a case when statement, but I'm stuck! How can I translate this statement to t-s...
Zones: MS SQL ServerDate Answered: 05/09/2000 Rating: 9.4 Views: 24
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 Rating: 7.8 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 Rating: 5.8 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 Rating: 6.6 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 Rating: 8.8 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 Rating: 6.2 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 Rating: 8.0 Views: 0
Hi Freinds, Please help me with the IIF function in sql Getting syntax error for following line at = sign iif (cast(rcv_stats_shelter_plus_chk_c as int)=1, 1, 0) The query is returning as s...
Zones: MS SQL ServerDate Answered: 09/24/2004 Rating: 8.8 Views: 34
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: Cold...Date Answered: 08/24/2004 Rating: 5.8 Views: 0