Search results

Do you mean something like: SELECT * FROM table (your table name goes here) WHERE date = [date?] Instead of actually "hard coding" the date, when you include it in the brackets, Access will ask you to specify the date you want. This would start you going, I hope.

anyone with some remote Oracle and Access experience who can answer this seemingly simple question?

Hello, I am doing a query into Oracle with MS-Access uisng the Query Design wizard where date is one of the parameters. The SQL View from the query window is: SELECT PRICEVALUE.PRICEDATE, PRICEVALUE.DELIVDATE, PRICEVALUE.PRICEINDEX, PRICEVALUE.PRICE FROM PRICEVALUE WHERE...