About Us

Ben[_4_]

oopps, my bad, i missed an ampersand in my code

it works!!

-----Original Message-----
Hi,

I'm trying to run a web query (.iqy) file using an asp
page. I've set up a formula that divides 2 columns and
that works but when I try to include an If statement into
the formula I get an message saying "Cannot download the
information you requested"

My asp code is as follows:

<TABLE border=0
<TR
<TDItem Num</TD
<TDInv Date</TD
<TDSale Amount</TD
<TDQuantity</TD
<TDAmount for Each</TD
<tdYes/No</td
</TR
<% While Not rsSales.EOF
x = x + 1
formula = "=c" & x & "/" & "d" & x
formula2 = "=IF(c" & x "=0,1,2)"

%
<TR
<TD align="left"<%=rsSales("ItemNum")%
</TD
<TD align="center"<%=rsSales("InvDate")%
</TD
<TD<%=rsSales("SaleAmt")%</TD
<TD<%=rsSales("Qty")%</TD
<TD FORMULA="<%=formula%"</TD
<TD FORMULA="<%=formula2%"</TD
</TR
<% rsSales.MoveNext%
<% Wend %
</TABLE

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert hard coded query criteria to Parameter Query	Melanie[_2_]	Excel Discussion (Misc queries)	0	July 15th 08 09:59 PM
Excel 2007 / MS Query - editing existing query to another sheet	Hotpepperz	Excel Discussion (Misc queries)	0	June 13th 08 06:53 PM
Importing Data via Web Query - Can values be passed to query?	[email protected]	Excel Discussion (Misc queries)	5	May 9th 06 06:21 PM
Save data retreived from query without saving query	Anthony	Excel Discussion (Misc queries)	0	January 25th 06 07:17 PM
Microsoft Query rejects "nz" function in Access Query	Vaughan	Excel Discussion (Misc queries)	0	May 4th 05 05:20 PM

Menu

About Us