Search results

I have tried posting this message before, but with no results. I am trying to get a query that will give me all of my customers and show what their last order date is. The query that I have now is coming back with ALL the dates the customers made purchases. Here is how I have the query set...

I am trying to run a query that will give me all of my customers who last purchased on or before 2004. I do not want anyone who purchased anything in 2005. I am including, name, address, telphone number, salesman, order date, and shipping method. I leave all criteria blank, and I have the...

trying to convert to 2003 format and I get conversion errors. They are in 2 tables. 1-customers table says -1605:could not find field "description" 2-orders table says -1522: No unique index found for the refrenced field of the primary table. Can anyone help? I can get in to create new reports...

I am trying to create a new query and a new report in my database. The program will not let me. The "new" is grayed out. Can anyone help me? :confused:

Help! I am trying to run a query that will give me customers who have a last order date of say January 2002. I am using the Access template Order Entry. I need to know what expression I can use to retreive these records. What I am doing right now in my query is putting the order date as...