Recent content by cindyem

How do I do this?

Hi, I have a Form that has two combo boxes: 1. Customer dropdown box followed by: 2. Locations dropdown box First, I want the user to select from the dropdown box the customer name, then after they have chosen the customer name, I want the second dropdown box to already find the list of the...

I see.. I'll keep trying, thanks so much. :D

Hi, I want a query which returns me the same 6,388 rows that I have in the orders table, except that now, I want an additional column showing the order of last year. For example, for SS 2008 I need SS 2007 order amount next to it. The query that you gave me are like a summary of the orders...

Hi, I've made this query : SELECT [Orders].ACCOUNTTYPE, [Orders].CUSTOMER, [Orders].REGION, [Orders].LocationCode, [Orders].CITY, [Orders].LocationName, [Orders].DEPT, [Orders].BRANDAB, [Orders].SEASON, [Orders].[Book$], (SELECT O.[Book$] FROM [Orders] as [O] where...

Hi guys, I'm so sorry that I'm very slow at this.. I've tried incorporating both of your queries into my table for the whole day now... but I have errors like: subquery can only return one value... , I then tried to run the subquery on its own but I get not only duplicate values but also some...

The database file only has my order table in it. I am sure all my previous queries are not useful anyway.. I really appreciate your help. Thanks a lot.

I've attached the file below. Thanks so much in advance!

Thank you so much for your reply!! I've studied your queries and the result is exactly how i wanted it.. but my order table already has ten thousands of order data inside and each doesn't have an orderID like how you set it up.. Any idea? Thanks a lot!

Actually the seasons go all the way down to 2001, so i am stuck on how you would create the second query that you suggested, on creating a query on just last year's info.. Do you know how the second query will look like? Sorry for the spam earlier i really thought i saw that i needed to post...

Hi everyone, I am running into trouble combining some things into one table. I have the following table: Notice that I have several seasons under every customer that makes order. I want to add two more columns to this table so that I can add last year's amount of that particular...