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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10181896.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10341220.html
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,...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20152158.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20263968.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20289091.html
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...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20404618.html
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)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20416302.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20830942.html
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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21098711.html
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...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21104254...
Zones:
Cold...Date Answered: 08/24/2004 Rating: 5.8 Views: 0
