i'm ok taxes 2013 tutorials
in this video I'm gonna be making the main report for the invoice so this is
I think possibly in 9th video in the
miniseries on invoices and play along
usual stuff follow the link below the video to the dollar section website now
taxes 2013 DV 52
and to that's not bad for a
okie dokie
an
process password or not
turning is possible okay
so in order to create the main invoice
we are going to need to create a query
and I'm for the main information on the scene then we're going to create
all gonna add the the sub invoice that I think we made
you read it hope you made it okay we're gonna die in
and think the from in fields
so and it's going to create task ok redesign
now the tables were gonna warn by thing
for a collection service table invoices table
bookings in table guests kiko key
so let's start with its a
start booking ID Niska
in worse ID I am
McKenna 1 the first and last name to the guest
cyclic in top Roman empty
condom to come builder
next guest sinkhole on
and we won table guests
door first name ampersand
open/close quotation marks this patient space in middle and
table guests talk last night
palaces take a quick look at that scarce
stuffing and the other things were going to warn
are as long as you can on the talking
day I am rotated discount from Table invoices
stronger okie dokie
family will call this
cleary
Harry query Harry
you sorry very bookings
for voices
okay twice a close to
and it's closed main form as well week
cleary bookings for invoice no idea
when I ll yeah at Aria
they are okay now gonna crate foam
order for Silas create a blank for
for to to straight reporters I actually
okay side
because a nice white detail section which is what
form so go to press a formerly property she
and record source we're gonna choose to be
weary bookings for invoices an
to come title know at us
kinda neat title in which local invoice
invoice answer added a tying the air
the time honest
day at a time in very nice K
now page header we don't really want anything in the page header
which can at the existing shows we've got here
a.m. invoice ID start with a
go to once you try to own better range
and click on stacked so that puts it together and layout
to his little bit better my opinion
and change the label 0
change it to say invoice number
so the invoice I deval
sensually be the invoice number she I go back to design feel took on
at existing fields we're gonna win booking ID as well
to a drug that next to the investor will actually
make to invisible some for the English side
the and what we want where do we wanna
case I'll say we won the
once I D Dave boxing
thank guest fight f ing
enough to make me a bit sparse a second booking Baker arranged to coincide
above less a guest even and surpass
I am change booking date to
dates of booking
fish is everything white-out that
column for the invoice ID and guess this is to then
to you for you take a look at it that's fine
using the control bomb click on these three boxes format
and were meant to be invisible so visible
no you don't miss a lie we were on the border style to be transparent
K and mom looking to be invisible
a to to the has a pool norm
cool shave your print preview
can it's fine to now organization can add in the summer for
she got a design geocaching to make enough space for the summer for so
track Services page for down click on guests
better range anger insert blood supply
and go to the bottom right the
creative in T cells and click Insert right
and then go to range she s been a range select 2-row
and merch so you can this is where we gonna drop the
invoice supper for now to converse
for invoices sought actual money speaks into layout
first she can hit
space sacred invoices Saab drug over
highest point in me are just drop any
I'll he says
actually know that did hit space you looking for which is fine
so you need to do an hour small problem
small problem me thinks go to
click in the top list thang called the necropsy middling
moss to filter don't think we've got the rocks
now you have to move go
a few ninety we've got to can I T
which either hush it worked in
have a was a oriental as wide an hour over the
and why the value down there
and taxing units one out seven more for their
even a little bit more an hour encroaching ok
page
not good news
showed
get inside okay a.m.
out guest is gone below national we want as a
in the control bomb miss click and drag to stop
the range sir
on pick up for the times okay so
kinda their provided the invoice
got the solver for saved this
and cooler for forces
I am perfect in a sec nice close-up
and let's go to for invoices sup good design view
let's make that as narrow as possible
suppressive for and data format
and scrollbars you will need a
saved and close that my life a number for invoices again
score was anymore right click into layout view
make sure you clicked on the foreign forces sup could've border-style:
transparent and we will be dropping knowing this tweet over the next year
will be dropping some stuff below
the the sub report
but what we wanted do you another thing you want to do
if I gotta print preview you can see the big issue we've got a good morning
what's on the pages of the sea and on since
so collect a lab to you process for
go to detail
and go to yet for snoop a jumper
of two sections in Africa 0 she say tango to print preview
you get one invoice per page
know that we only get ahead on the first invoice for our next the Africana
be print and online voice a time so that's absolutely fine
yetta service can alright I am pass a bill or dismiss course not the top so I
just
sold out to compare particular regions below
click on invoice number tokens above
and go previews similar looks like
yeah I mean a sore thats just
stoking the flames acceptability
I'm re: so that's going to be enough for for that sweet
we have ninety major we've just trade top the main invoice BEFORE
drop de subir foreign and on a bit formatting
and get you stuff to go back over stuff in the next video ever going to be
playing some sub toning and tightening in this part
up down here to refill out the invoice nicely
okay so thank you joie chen et and see next video