The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Hello there, I'm having a bit of trouble with my AS level Computing coursework, which is entitled "Tods Tyres", I'm zipping through the documentation nicely (thanks to some help from Paradox - nice one mate) but I've noticed i'm missing some features in my database and I cannot work out how to do them.
I was wondering if anyone could give us a hand?
Firstly, reports.
For this project I have to create an invoice to give to the customer. I have that pretty much sorted, in a way, but I can't work out how to do this.
Say if the customer is called "Bob" and he had is tyre's serviced today, how would I go about opening the report on *that* invoice (instead of having to open the report, then going through each entry in the database until I reach the correct one)?
And secondly, this is a query related question...
When the customers details are entered, I have an option to check whether the customer is eligable for discount or not, and for "Yes" you just tick the checkbox. I want to know what the correct syntax is for a query to let me calculate the grand total.
(Discount is set to 5% off)
Example (written in psuedo code if you get me)
if checkbox is ticked, then bob gets 5% taken off the final price, if the textbox is not ticked, then nothing is taken off.
I'd be grateful for any help that is received.
I was wondering if anyone could give us a hand?
Firstly, reports.
For this project I have to create an invoice to give to the customer. I have that pretty much sorted, in a way, but I can't work out how to do this.
Say if the customer is called "Bob" and he had is tyre's serviced today, how would I go about opening the report on *that* invoice (instead of having to open the report, then going through each entry in the database until I reach the correct one)?
And secondly, this is a query related question...
When the customers details are entered, I have an option to check whether the customer is eligable for discount or not, and for "Yes" you just tick the checkbox. I want to know what the correct syntax is for a query to let me calculate the grand total.
(Discount is set to 5% off)
Example (written in psuedo code if you get me)
if checkbox is ticked, then bob gets 5% taken off the final price, if the textbox is not ticked, then nothing is taken off.
I'd be grateful for any help that is received.
Miserableman wrote:
> How are you calculating, storing and displaying the final price at
> the moment? How are your relevant tables set up?
Right, I've got a query named "Invoice Query", which has all the relevant fields on it. This is linked to a report, which is the invoice. In fact, I'll upload a few screenshots to show what I mean...
http://djh-world.com/images/pic1.png
http://djh-world.com/images/pic2.png
The "ticked" discount field is in "tblCompanyInformation"
> How are you calculating, storing and displaying the final price at
> the moment? How are your relevant tables set up?
Right, I've got a query named "Invoice Query", which has all the relevant fields on it. This is linked to a report, which is the invoice. In fact, I'll upload a few screenshots to show what I mean...
http://djh-world.com/images/pic1.png
http://djh-world.com/images/pic2.png
The "ticked" discount field is in "tblCompanyInformation"
gamezfreak wrote:
> Say if the customer is called "Bob" and he had is tyre's
> serviced today, how would I go about opening the report on *that*
> invoice (instead of having to open the report, then going through
> each entry in the database until I reach the correct one)?
One way which springs instantly to mind is to have a query that only retrieves Bobs tyre service, and make that query the data source of the report.
> When the customers details are entered, I have an option to check
> whether the customer is eligable for discount or not, and for
> "Yes" you just tick the checkbox. I want to know what the
> correct syntax is for a query to let me calculate the grand total.
>
> (Discount is set to 5% off)
>
> Example (written in psuedo code if you get me)
>
> if checkbox is ticked, then bob gets 5% taken off the final price, if
> the textbox is not ticked, then nothing is taken off.
How are you calculating, storing and displaying the final price at the moment? How are your relevant tables set up?
If you want to contact me directly, [email protected] is my MSN.
> Say if the customer is called "Bob" and he had is tyre's
> serviced today, how would I go about opening the report on *that*
> invoice (instead of having to open the report, then going through
> each entry in the database until I reach the correct one)?
One way which springs instantly to mind is to have a query that only retrieves Bobs tyre service, and make that query the data source of the report.
> When the customers details are entered, I have an option to check
> whether the customer is eligable for discount or not, and for
> "Yes" you just tick the checkbox. I want to know what the
> correct syntax is for a query to let me calculate the grand total.
>
> (Discount is set to 5% off)
>
> Example (written in psuedo code if you get me)
>
> if checkbox is ticked, then bob gets 5% taken off the final price, if
> the textbox is not ticked, then nothing is taken off.
How are you calculating, storing and displaying the final price at the moment? How are your relevant tables set up?
If you want to contact me directly, [email protected] is my MSN.
Gah, I'm still stuck on how to do this.
BlueEagle tried to help but it never worked.
BlueEagle tried to help but it never worked.
Cheers, I'm off to a party now, i've added you though.
gamezfreak wrote:
> I'd be grateful for any help that is received.
I'm goin out now, but if you have MSN add me, and i'll help you out when i get back.
> I'd be grateful for any help that is received.
I'm goin out now, but if you have MSN add me, and i'll help you out when i get back.
*pop*
Hello there, I'm having a bit of trouble with my AS level Computing coursework, which is entitled "Tods Tyres", I'm zipping through the documentation nicely (thanks to some help from Paradox - nice one mate) but I've noticed i'm missing some features in my database and I cannot work out how to do them.
I was wondering if anyone could give us a hand?
Firstly, reports.
For this project I have to create an invoice to give to the customer. I have that pretty much sorted, in a way, but I can't work out how to do this.
Say if the customer is called "Bob" and he had is tyre's serviced today, how would I go about opening the report on *that* invoice (instead of having to open the report, then going through each entry in the database until I reach the correct one)?
And secondly, this is a query related question...
When the customers details are entered, I have an option to check whether the customer is eligable for discount or not, and for "Yes" you just tick the checkbox. I want to know what the correct syntax is for a query to let me calculate the grand total.
(Discount is set to 5% off)
Example (written in psuedo code if you get me)
if checkbox is ticked, then bob gets 5% taken off the final price, if the textbox is not ticked, then nothing is taken off.
I'd be grateful for any help that is received.
I was wondering if anyone could give us a hand?
Firstly, reports.
For this project I have to create an invoice to give to the customer. I have that pretty much sorted, in a way, but I can't work out how to do this.
Say if the customer is called "Bob" and he had is tyre's serviced today, how would I go about opening the report on *that* invoice (instead of having to open the report, then going through each entry in the database until I reach the correct one)?
And secondly, this is a query related question...
When the customers details are entered, I have an option to check whether the customer is eligable for discount or not, and for "Yes" you just tick the checkbox. I want to know what the correct syntax is for a query to let me calculate the grand total.
(Discount is set to 5% off)
Example (written in psuedo code if you get me)
if checkbox is ticked, then bob gets 5% taken off the final price, if the textbox is not ticked, then nothing is taken off.
I'd be grateful for any help that is received.