Please Help Me!

[steve09]

I don't mind helping if you get stuck, I don't have the time to do the work for you.
Access ships with many sample DBs, an orders sample is included that you can use to learn from

Fair enough.
I just have no idea

Steve.

 

[RuralGuy]

Steve,
As I said earlier, try playing around with the Query Builder. Pressing the Sigma button while you are in the QBE will make your query a Totals query. It is the button that looks like a sharp E.

 

[steve09]

Steve,
As I said earlier, try playing around with the Query Builder. Pressing the Sigma button while you are in the QBE will make your query a Totals query. It is the button that looks like a sharp E.

Just been having a play about with it.
I know what I need is there, its now just a matter of doing it!

Once I have done the query, how do I attach it to my "Place an order" form so it update the total price in the "CostOfOrder" text box?

Thanks!
Steve

 

[RuralGuy]

You could do a DSum() on the static query as one way.

 

[Rich]

Stay with the Totals query method and use DLookUp on the query for the order ID

 

[steve09]

I still haven't been able to do it
This is the only thing left for me to do now, completed the rest of the booklet today.

RG/Rich, where do I attach the query to and how would I do it?

Would I put it on the "On Load" event?

Thanks chaps.
Steve

 

[RuralGuy]

Steve,
Have you got *any* results you can use yet while playing around in the Query Builder?

 

[steve09]

Steve,
Have you got *any* results you can use yet while playing around in the Query Builder?

No RG, nothing as of yet
If nobody on here can help me work it out, I'm hoping my Tutor can help me.

Still playing about with it...a day on

Steve

 

[RuralGuy]

Can't you even create a query that joins the orderline and sandwich tables?

 

[steve09]

Can't you even create a query that joins the orderline and sandwich tables?

It's fairly late now
I'l take the database with me to University and have a try at it then.

Report back tomorrow sometime, so keep a look out!

Steve

 

[RuralGuy]

Will do. Remember, you are the one trying to learn and you will learn a lot more by trying it yourself than having any one of us just spoon feed you the solution. Most of us here are glad to help someone gain knowledge by pointing them in the right direction. If you get stuck again then we'll pitch in and get you going, but you need to put in some effort so we can guage how you learn and where you might need help. If you want someone to do the work then the going rate starts at $100.00 per hour and goes up from there, in advance. Just assisting is free.

 

[steve09]

Lo RG!

Just in my Database lab session now, going to ask the Tutor to help me

Steve!

 

[steve09]

My teacher couldn't do it either!

What do I do now

Steve.

 

[RuralGuy]

Create a query that joins the orderline and sandwich tables. Let us know when you have it saved.

 

[steve09]

Create a query that joins the orderline and sandwich tables. Let us know when you have it saved.

Done!...

Steve.

 

[RuralGuy]

What field did you use to join the two tables? What is the relationship? 1:1 or 1:M

 

[steve09]

What field did you use to join the two tables? What is the relationship? 1:1 or 1:M

It was Sandwich to Orderline ... 1:M

and the fields that were used was SandwichNo to SandwichNo

Steve!

 

[RuralGuy]

Have you specified any sort order yet? If so, which field?

 

[RuralGuy]

Steve,
Here's just one approach to the issue.

 

[steve09]

Steve,
Here's just one approach to the issue.

WOW RG, that is so cool and so much better.

I would like to thank you for your patience, time and effort you have put in, in helping me over the past couple of days.

All I need to do now is my Switchboard then it is complete.

Thank you once again!

A very happy Steve