Recent content by Armesh

INstead of using a table, can I use a query? Because query can automatically take and update values from other field compared to a new table. Is this ok? Or should I use a table and there is a way to keep the fields matched with a table?

My lecturer is useless, she comes to class late, doesn't teach, she's a slide reader, poor experience in Access, even I'm better. I did the whole assignment using google on my self. Ok so now I understand why things weren't working, it was the multi-valued Gift Set field in the Customer Order...

Or 2nd: Should I make a junction table containing Gift Set and Price field. Then use the "Lookup Column" option for both the fields? (Gift Set lookup from Gift Set field in customer order table Price lookup from Price field in Gifts table)

Ok, I kindda get what you said. So 1st: Should I create a separate table where the ONLY gift set orders for each individual customers are stored? The problem is since each individual customer order multiple gift sets, the fields in the junction table would be multi-valued also. So its ok to...

Its just that 1 last part of the last query question.... submission is on 4 Sep.... Been stuck at this question for days..... really need someone to show me how to do it, had to ask here as last resort. Please help me man. Its just 1 small part... Not like I'm posting my whole big assignment...

----------

The gift set LIST in the customer order table is set as raw source to the gift set FIELD of the Gifts table.

Ya sumting like that.... If you look at my database, the customer orders are multiple choice list. So 1 customer may order Flower basket, Chocolate and Candies. So now I want to assign the price for the items in the query, The prices are already given in a seperate table.. but its just not...

I do have a pricing table... but I dunno what to do with it.. If it put it in the query, it doesn't assign to the respective items. It will just display some prices.. but doesn't add up prices of each individual product ordered by the specific customer. Try taking a look at my database, I have...

Ok, first just Create>Query Design. Then select the fields that I wan from the tables I wan. Customer Identification number, customer first and last names taken from customer membership info table, Gift set taken from customer order record table. Then set the criteria for gift set to Not Like...

I've done almost the whole part but stuck at 1 last query question. It says: Display Customer Identification number, customer first and last names, and gift set (excluding flower stalks) where customers are paying more than $30 but less than $120. I'm having problem with the underlined part...