Question

How come my query isn't running correctly?

It is meant to contain fields: PONumber, Account, orderDate, itemNumber, and numberOrdered. Those come from the table OrderInfo. It is meant to show all the information for orderDate 2/16/2012.

$Project 4 Part2 LAB: Database- CAUsers\Christinel DesktoplKathryn Sc Create External DataDatabase Tools Help Tell me what you$

Query Tools Project 4 Part2 File Home CreateExternal Data Database Tools Help Design Tell me wh Insert Ro ① Union Pass-Through Show X Delete R View Run Select Make Append Update Crosstab Delete Table ビData Definition : e-Bul Table Results Query Type All Access Obie... OQuery1Orderinfo SELECT PONumber, Account, orderDate, itemNumber, numberOrdered FROM Orderlnfo Search.. WHERE orderDate-2/16/2012 Tables Orderlnfo Product!nfo Reports Relationships for Project 4 Pa... Project 4 Part2 LAB: Database- CAUsers\Christinel DesktoplKathryn Sc Create External DataDatabase Tools Help Tell me what you want to do File Home aac Replace Calibri Ascending ▼ Selection Totals Cut New l Descending Advanced Filter Spelling E Copy Go To ViewPaste Refresh Find 순. Remove Sort Select ▼Toggle Filter Format Painter All.XDelete More Views Clipboard Sort & Filter Records Find Query?Orderinto All Access Obje... PONumber orderDate itemNumber numberOrdered Account Search.. Tables Orderlnfo Productinfo Reports Relationships for Project 4 Pa...

Answer 1

Your query is not running correctly because Access database system have little different syntax compared to other traditional database systems like Oracle, MS SQL server.

In MS Access, if we are comparing the Date field, we need to put '#' symbol around it or in other words the date string need to be enclosed inside '#' symbol.

So, instead of writing 2/16/2012, you need to do it as

#2/16/2012#

and you will get the desired results.

Let me know, if you still find any difficulty, I would be happy to assist.

Thanks!