Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |