Search results

right so i've got it like this: [Date DeliveredCollected]< DateAdd("yyyy",-1,Date()); this code is going into the query i've named "DeliveryTbl Query" under the header "date delivered collected" run down on what im doing: once a computer system is over 12 months i want it to go into an...

Mile-O-Phile sorry about this, im a bit confused. the field is called: date delivered/collected do i put that in instead of "MyField*? for "yyyy" do i put this years date? and for "date" do i put anything in? :confused: thanks for the quick reply Mile-O-Phile.

help needed to carry out a query, only want records under 12 months old to appear i am building a database in Access for my final year: "A2 ICT" course which i have based on a computer shop, im trying to run a query which removes the records over 1 year old and just leaves the records that are...