Dear Sir/Madam,
I am developing an application in ASP. The database I am using is access. I would be grateful if you could help me solve a small problem. My problem is in MS-Access.
I have a table which has certain values in a particular field. These values are numbers separated by an ‘Or’. They are inserted into this table from a web page (throught ASP). I need them to be passed to an access query (procedure) as a subquery.The problem is when there is a single value (without OR) the query executes perfectly, however when more that 1 values are present separated with an ‘Or’ the query fails to return any result.
When the values are manually typed in the ‘criteria’ dialog, the query returns the results, however when they are passed in the form of a sub query (SELECT[
Kindly help me out of this problem. Alternatively please send me addresses of sites/people who can help me solve this problem.
Awaiting your reply.
Viplav Kambli