Search results

okay, so, if I write a query with just the order details table, and select the unit price, product id, quantity and make an expression for a total, (unit price x quantity), and if it works correctly, where do i paste that sql into my original query? I'm really lost when it comes to this.

This is the sql that I am using right now and the query works correctly. It is like you said, I have diffrent salesman selling a customer and also diffrent shipping methods. SELECT DISTINCTROW Customers.CompanyName, Customers.Name, Customers.Address, Customers.city, Customers.state...

Great, that worked. Now what I want to do is add another table, Order Details, where I would take, unit price, quantity, product id, and the expression ([Quantity]*[UnitPrice]. When I do this and try to run the query, it comes up and says The SQL statement could not be executed because it...

I want the query to give me all of my customers, but only once and to show the last date that they were sold. I really need help!!

Do you mean that I should have 2 seperate queires? If so, then the problem there is that I can not create new queries.

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...

also, if I group the date by "last" it is still incorrect. It said one customers last date was in july, when I check their history, the real last date was in october. What could be the problem?

what do you mean by grouping? I already have the order date grouped at "max". Do you mean group the customer also? If so, what do I group it at? Last?

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...

I did open a new 2003 db and imported all the tables, forms, reports, etc., but it still would not import the customers table. I then went back to the 97 db and exported that table into the 2003 db. That seemed to work, but I still cannot add additonal orders to any customers, the button is...

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...

no one else will be using the database. whats the difference between an MDB and and an MDE? is that an extension of the database? why would I need to do that?

yes, it is 97. Now I have Office 2003. Another question, when I convet the db to 2003, I should be able to create new forms & queries,& reports?

Okay, I appreciate your help, because I am very new at this. I have some knowledge of what you are talking about but I really dont understand much about objects & references. So, I will let you know what my program is saying. I can get to the global code, (1st thing I noticed is that in the...

i dont know what refrence I should be looking for.

yes, everything is dimmed out. Even forms. I dont know what reference I should be looking for

I am using Access 2003, Sp1 OS is XP professional no one else in databsae, Yes it worked before and it is a mdb

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...