hello and welcome to access 2013 tutorials
this will be hopefully the lost in
miniseries on invoices and Megan be looking at sub totaling
the main invoice and calling that from the
datasheet I am so play-along
you stuff like that video dissection website access 2013 DB
53 open our
casa is password
and
let us take a look the form I just thought
for invoices inheritance K
won't do today his phone open and print preview or more vs
you've got the in which got the invoice number date booking guests and you've
got
the Danish she which is a suburb full
which lists the relevant information
guard in a given invoice I'm
followed on the nation's drop some fields given some subtitles in totals in
total paid in
gonna stuff like that so without further ado
good design view scroll down
and money yes
has perfect guy so to calm
text books just drop it exports and
seem to have
made a textbox disappear know that's possible
so just controls it on others but Perrigo
okay so obviously know me you've got label when and you've got
text books in this case can be calculated field first one
is actually first text books I'm actually gonna be free to text boxes
down
occurs or I will make sure the label to be a calculate so as well
so that's emerged out
and it's cooler
text they believe that doesn't really matter
names okay so this
is going to look like a typical a was actually gonna be
a calculated field and we're gonna go to data
and click on the ellipsis so equals
sup tote so demme's wish
and public space ampersand
if you get a discount reform to
said so is going to be an old is probably about from
show it to you to report
we can see this invoices sub-total with 0.1 cent it's not surfer 1 percent is
0.1
from one which is actually 10 percent so many to form at this number
to Sen so it's quite easy do HD
just house the discount in
former percent pressure
Amreeka subtotal wish
oh okay that's enough fun
okay treated the said here and say
tests count so it looks like to
subtotal 10 percent discount and we're gonna drop us up to go in there
okay so we'll need to do you need to go look we're getting the figures from so
again from a query which is
weary cost payments Union are interested
in related bookings but we're not interested in
a.m. payments assume sorted on this one query
course fence unions sorts it's yes
okay so you wanna booking we did you learn anything with a motor was minus-1
which means is charged one is for payments criminal
totaling payments I am at the reactionary
then need to take the send discount of it
so we got couple a.m.
point I'll calculations to make some summing
festival summing the amount resumming the amount in
adjusted a summing the just the stray mouse when I can take into the air
taking into account the eighty this point so gonna click on
control so so when you doing like a complicated d some
a breakdowns d some
keep it nice and simple to star amount
from and its query costs
payments Union sort it's a query costs
pain min its Union
sorted and just
okay and see if that works for civil okay so that those were
I am to now only to do is at a criteria
to see me do this couple times forces took in ninety
he calls ampersand booking ID
symbolism see if that works 1890 that's brilliant now we need where the
multiplier
equal whose -1
amps and and
mall to Playa equals
-1 cellmark's
yet so up to 480 case and now what we need to do
he's having this figure which in this case is 480
we need to take discount of so if you multiply 480 by the number one
you get for 80 if we have the number one we -0.1 of
they become 0.96 you multiply 480 buzzer 49
you get ninety center for tonight so
times open toes bracket one minus
discount Amreeka we get cancelled
very intelligent thing to time strike again
bombing one minus discount
a cane City Council a the
we get a 4-3 do a civilian
okay to change the format currency so
we can see that the sum total with stems and discount people's 432
that's great a great so that's move on to the next one
subject the more each myself shellfish
and must drop I A
new 1n
and this one's gonna be VAT you can
connect and VAT equals
d look up to you need to the vatz in
actually where's the VAT is a very good point
table bookings 40 minus invoices surely
VAT rates in invoices okay
so fact as we were equals D
lookup and
pictures from VAT I might be wrong
whereas it's in table in
voices and we need a criteria were gonna say
booking it.
FK equals
and King ID
just a super and if we do that I have letter
to your figure week to into to fall under four got a format
and K tune four-man
pear-shaped texan an ascot arrange an answer
below tougher times
if you're okay let's drop another
text books in there okay so this one
is gonna be total
what we're gonna be doing is
basically gonna be looking up the same is this
and minus in this kind of incentive looking up a.m.
without VAT we gonna look out with VAT so I see
muslims or this equation
Chelsea okay just SCANA knowing this layout
accuse come to the top the structure in there
and the mound thing is Inc VAT
sister fix anything up
yes did and former
make that currency process my nest of the
20 percent discount think
one thinks
France on think this
Royce 576
ice months of 10 percent discount yes I 5184 use 576
-67
725
a 67-60 Essex 25
use $25 plus 50 CSS cracked okay
cool and many struck another
subtotal in
and this one's going to be total
paid to go here
now I ganar suggest you just wrote this for me
I work in their for that now where D some men
amount you're the but I D love multiplier
equal one to taxi means we're now total in the payments mates
press OK see what we get 1 for 10
payment I'm
payment no time
thankfully for us 412 4013
yes correct on for 10 K former and
currency and the lost thing that's gonna leave
as balance outside let's take this
and name it text total
and let's take this
and you name it txt total
pay gonna Party Rock
commands alone Americans
good design job from soon trip
cool balance she's going to
equal she's paid a thousand
if you paid $1000 and the cost is 1500
balance should be -0500 test text
total paid minus txt
tote so I make that
she's 891 yep that's correct
and former a a
currency okay and
personal control bomb click on all northeast to go to border-style:
transparent for Nash ago
some class sup Susan Connie save it do print preview
me
so we get some totaling
information which is pretty cool okay so that's that's for the totals
a one last thing I wanna do was that close that was yummy go here
on a per ha maybe I'm oversized t
auditor column it says print for invoice
undisclosed main go find clearly she knows Creary
invoices extended yes please go to design view
take on here docents
column became the top builder
and school prin and for in
needs to be in quotation marks
okay expressed DS here
for members extended DS
to design view ok to design
existed shoe its friend is in there
my notes
from signature save and close to us trying it again
design go
to use existing showing up for nasa structure in at the top
today she view should be moved away
night visited it hands up if you see print and others
cheney packard
for splice hyperlink always
and on click Acree builder
we're gonna say open for forename
is for invoices where equals
in Voice
alrighty equals ampersand
my voice I D checked lines that Owen
as you make a print preview said a report saved acts like
not that they should use already in Amiga
first number two and fitness one
again with someone okay full
accept any series 10 video miniseries on invoicing
done a as escaped my attention that the
invoices are nonsense because the on balance please feel free to
add and remove payments to your heart's content to make them balanced
an and that's pretty much it for the invoice inside already really just
wanting
to you do have to database which is to make that is a continuous form that we
can use condoms
a.m. visual representation golf tee bookings in the rooms
for or counselor annex she video so just another show many cities estimate on
okay thank you for watching save all that and see you next year