:banghead:
Hello,
I am writing a WEB Access 2010 application and I have just discovered that I cannot use a SQL SELECT statement within my Query. The SQL STATEMENT creates a new column called CondPrice within [CFLHPtbl] populated with a lookup and match from a comparison between [EQPPrice] CFLHPtbl. The SQL SELECT below works GREAT, but I can NOT publish it to SharePoint. I am new to Access 2010 Web DB, can anyone show me how to accomplish this within a Web Macro?
(select eqpprices.price from eqpprices where productnum = cflhptbl.condmodel and eqpprices.profilenum = testval ) AS CondPrice
*Please note that “testval” is just placed there for testing. I want to be able to replace the “testval” with a selected value from a combo box.
Thank you in advance for any help or suggestions.
Hello,
I am writing a WEB Access 2010 application and I have just discovered that I cannot use a SQL SELECT statement within my Query. The SQL STATEMENT creates a new column called CondPrice within [CFLHPtbl] populated with a lookup and match from a comparison between [EQPPrice] CFLHPtbl. The SQL SELECT below works GREAT, but I can NOT publish it to SharePoint. I am new to Access 2010 Web DB, can anyone show me how to accomplish this within a Web Macro?
(select eqpprices.price from eqpprices where productnum = cflhptbl.condmodel and eqpprices.profilenum = testval ) AS CondPrice
*Please note that “testval” is just placed there for testing. I want to be able to replace the “testval” with a selected value from a combo box.
Thank you in advance for any help or suggestions.
