1
00:00:01,649 --> 00:00:04,500
hello and welcome to access 2013 tutorials

2
00:00:04,500 --> 00:00:08,028
this will be hopefully the lost in

3
00:00:08,028 --> 00:00:12,379
miniseries on invoices and Megan be looking at sub totaling

4
00:00:12,380 --> 00:00:16,830
the main invoice and calling that from the

5
00:00:16,829 --> 00:00:20,099
datasheet I am so play-along

6
00:00:20,100 --> 00:00:25,150
you stuff like that video dissection website access 2013 DB

7
00:00:25,149 --> 00:00:28,618
53 open our

8
00:00:28,618 --> 00:00:32,238
casa is password

9
00:00:32,238 --> 00:00:36,799
and

10
00:00:36,799 --> 00:00:40,199
let us take a look the form I just thought

11
00:00:40,200 --> 00:00:43,760
for invoices inheritance K

12
00:00:43,759 --> 00:00:47,649
won't do today his phone open and print preview or more vs

13
00:00:47,649 --> 00:00:51,948
you've got the in which got the invoice number date booking guests and you've

14
00:00:51,948 --> 00:00:52,378
got

15
00:00:52,378 --> 00:00:57,439
the Danish she which is a suburb full

16
00:00:57,439 --> 00:01:01,108
which lists the relevant information

17
00:01:01,109 --> 00:01:05,349
guard in a given invoice I'm

18
00:01:05,349 --> 00:01:09,719
followed on the nation's drop some fields given some subtitles in totals in

19
00:01:09,719 --> 00:01:10,780
total paid in

20
00:01:10,780 --> 00:01:14,909
gonna stuff like that so without further ado

21
00:01:14,909 --> 00:01:18,189
good design view scroll down

22
00:01:18,188 --> 00:01:21,309
and money yes

23
00:01:21,310 --> 00:01:24,609
has perfect guy so to calm

24
00:01:24,609 --> 00:01:28,969
text books just drop it exports and

25
00:01:28,969 --> 00:01:32,859
seem to have

26
00:01:32,859 --> 00:01:37,629
made a textbox disappear know that's possible

27
00:01:37,629 --> 00:01:42,000
so just controls it on others but Perrigo

28
00:01:42,000 --> 00:01:45,810
okay so obviously know me you've got label when and you've got

29
00:01:45,810 --> 00:01:50,109
text books in this case can be calculated field first one

30
00:01:50,109 --> 00:01:54,549
is actually first text books I'm actually gonna be free to text boxes

31
00:01:54,549 --> 00:01:55,079
down

32
00:01:55,078 --> 00:01:59,819
occurs or I will make sure the label to be a calculate so as well

33
00:01:59,819 --> 00:02:02,908
so that's emerged out

34
00:02:02,909 --> 00:02:06,280
and it's cooler

35
00:02:06,280 --> 00:02:09,659
text they believe that doesn't really matter

36
00:02:09,659 --> 00:02:12,789
names okay so this

37
00:02:12,789 --> 00:02:16,259
is going to look like a typical a was actually gonna be

38
00:02:16,259 --> 00:02:20,549
a calculated field and we're gonna go to data

39
00:02:20,550 --> 00:02:25,110
and click on the ellipsis so equals

40
00:02:25,110 --> 00:02:31,129
sup tote so demme's wish

41
00:02:31,128 --> 00:02:34,709
and public space ampersand

42
00:02:34,709 --> 00:02:40,300
if you get a discount reform to

43
00:02:40,300 --> 00:02:45,910
said so is going to be an old is probably about from

44
00:02:45,909 --> 00:02:48,919
show it to you to report

45
00:02:48,919 --> 00:02:54,568
we can see this invoices sub-total with 0.1 cent it's not surfer 1 percent is

46
00:02:54,568 --> 00:02:55,699
0.1

47
00:02:55,699 --> 00:02:59,679
from one which is actually 10 percent so many to form at this number

48
00:02:59,680 --> 00:03:04,250
to Sen so it's quite easy do HD

49
00:03:04,250 --> 00:03:08,439
just house the discount in

50
00:03:08,439 --> 00:03:13,919
former percent pressure

51
00:03:13,919 --> 00:03:18,299
Amreeka subtotal wish

52
00:03:18,300 --> 00:03:21,370
oh okay that's enough fun

53
00:03:21,370 --> 00:03:25,330
okay treated the said here and say

54
00:03:25,330 --> 00:03:29,299
tests count so it looks like to

55
00:03:29,299 --> 00:03:33,939
subtotal 10 percent discount and we're gonna drop us up to go in there

56
00:03:33,939 --> 00:03:38,340
okay so we'll need to do you need to go look we're getting the figures from so

57
00:03:38,340 --> 00:03:39,989
again from a query which is

58
00:03:39,989 --> 00:03:44,060
weary cost payments Union are interested

59
00:03:44,060 --> 00:03:47,900
in related bookings but we're not interested in

60
00:03:47,900 --> 00:03:54,900
a.m. payments assume sorted on this one query

61
00:03:55,098 --> 00:03:59,048
course fence unions sorts it's yes

62
00:03:59,049 --> 00:04:04,188
okay so you wanna booking we did you learn anything with a motor was minus-1

63
00:04:04,188 --> 00:04:07,878
which means is charged one is for payments criminal

64
00:04:07,878 --> 00:04:12,060
totaling payments I am at the reactionary

65
00:04:12,060 --> 00:04:15,340
then need to take the send discount of it

66
00:04:15,340 --> 00:04:19,790
so we got couple a.m.

67
00:04:19,790 --> 00:04:23,530
point I'll calculations to make some summing

68
00:04:23,529 --> 00:04:29,219
festival summing the amount resumming the amount in

69
00:04:29,220 --> 00:04:34,550
adjusted a summing the just the stray mouse when I can take into the air

70
00:04:34,550 --> 00:04:38,350
taking into account the eighty this point so gonna click on

71
00:04:38,350 --> 00:04:41,689
control so so when you doing like a complicated d some

72
00:04:41,689 --> 00:04:45,009
a breakdowns d some

73
00:04:45,009 --> 00:04:49,509
keep it nice and simple to star amount

74
00:04:49,509 --> 00:04:52,800
from and its query costs

75
00:04:52,800 --> 00:04:56,810
payments Union sort it's a query costs

76
00:04:56,810 --> 00:05:00,189
pain min its Union

77
00:05:00,189 --> 00:05:03,529
sorted and just

78
00:05:03,529 --> 00:05:07,250
okay and see if that works for civil okay so that those were

79
00:05:07,250 --> 00:05:13,639
I am to now only to do is at a criteria

80
00:05:13,639 --> 00:05:17,780
to see me do this couple times forces took in ninety

81
00:05:17,779 --> 00:05:21,049
he calls ampersand booking ID

82
00:05:21,050 --> 00:05:25,829
symbolism see if that works 1890 that's brilliant now we need where the

83
00:05:25,829 --> 00:05:26,740
multiplier

84
00:05:26,740 --> 00:05:31,150
equal whose -1

85
00:05:31,149 --> 00:05:36,339
amps and and

86
00:05:36,339 --> 00:05:40,038
mall to Playa equals

87
00:05:40,038 --> 00:05:44,250
-1 cellmark's

88
00:05:44,250 --> 00:05:49,410
yet so up to 480 case and now what we need to do

89
00:05:49,410 --> 00:05:52,560
he's having this figure which in this case is 480

90
00:05:52,560 --> 00:05:57,538
we need to take discount of so if you multiply 480 by the number one

91
00:05:57,538 --> 00:06:02,228
you get for 80 if we have the number one we -0.1 of

92
00:06:02,228 --> 00:06:06,159
they become 0.96 you multiply 480 buzzer 49

93
00:06:06,160 --> 00:06:09,550
you get ninety center for tonight so

94
00:06:09,550 --> 00:06:13,650
times open toes bracket one minus

95
00:06:13,649 --> 00:06:17,519
discount Amreeka we get cancelled

96
00:06:17,519 --> 00:06:21,668
very intelligent thing to time strike again

97
00:06:21,668 --> 00:06:25,689
bombing one minus discount

98
00:06:25,689 --> 00:06:28,889
a cane City Council a the

99
00:06:28,889 --> 00:06:32,439
we get a 4-3 do a civilian

100
00:06:32,439 --> 00:06:35,719
okay to change the format currency so

101
00:06:35,720 --> 00:06:40,330
we can see that the sum total with stems and discount people's 432

102
00:06:40,329 --> 00:06:43,859
that's great a great so that's move on to the next one

103
00:06:43,860 --> 00:06:47,490
subject the more each myself shellfish

104
00:06:47,490 --> 00:06:50,579
and must drop I A

105
00:06:50,579 --> 00:06:53,779
new 1n

106
00:06:53,779 --> 00:06:57,739
and this one's gonna be VAT you can

107
00:06:57,740 --> 00:07:04,740
connect and VAT equals

108
00:07:05,459 --> 00:07:09,638
d look up to you need to the vatz in

109
00:07:09,639 --> 00:07:14,139
actually where's the VAT is a very good point

110
00:07:14,139 --> 00:07:18,870
table bookings 40 minus invoices surely

111
00:07:18,870 --> 00:07:22,129
VAT rates in invoices okay

112
00:07:22,129 --> 00:07:25,639
so fact as we were equals D

113
00:07:25,639 --> 00:07:29,038
lookup and

114
00:07:29,038 --> 00:07:32,318
pictures from VAT I might be wrong

115
00:07:32,319 --> 00:07:35,389
whereas it's in table in

116
00:07:35,389 --> 00:07:40,310
voices and we need a criteria were gonna say

117
00:07:40,310 --> 00:07:43,329
booking it.

118
00:07:43,329 --> 00:07:46,939
FK equals

119
00:07:46,939 --> 00:07:50,288
and King ID

120
00:07:50,288 --> 00:07:53,500
just a super and if we do that I have letter

121
00:07:53,500 --> 00:07:58,399
to your figure week to into to fall under four got a format

122
00:07:58,399 --> 00:08:01,978
and K tune four-man

123
00:08:01,978 --> 00:08:06,449
pear-shaped texan an ascot arrange an answer

124
00:08:06,449 --> 00:08:10,419
below tougher times

125
00:08:10,418 --> 00:08:15,378
if you're okay let's drop another

126
00:08:15,379 --> 00:08:19,150
text books in there okay so this one

127
00:08:19,149 --> 00:08:22,788
is gonna be total

128
00:08:22,788 --> 00:08:26,628
what we're gonna be doing is

129
00:08:26,629 --> 00:08:29,919
basically gonna be looking up the same is this

130
00:08:29,918 --> 00:08:34,168
and minus in this kind of incentive looking up a.m.

131
00:08:34,168 --> 00:08:38,399
without VAT we gonna look out with VAT so I see

132
00:08:38,399 --> 00:08:42,700
muslims or this equation

133
00:08:42,700 --> 00:08:46,759
Chelsea okay just SCANA knowing this layout

134
00:08:46,759 --> 00:08:50,049
accuse come to the top the structure in there

135
00:08:50,049 --> 00:08:53,199
and the mound thing is Inc VAT

136
00:08:53,200 --> 00:08:56,950
sister fix anything up

137
00:08:56,950 --> 00:09:00,930
yes did and former

138
00:09:00,929 --> 00:09:05,859
make that currency process my nest of the

139
00:09:05,860 --> 00:09:12,580
20 percent discount think

140
00:09:12,580 --> 00:09:15,690
one thinks

141
00:09:15,690 --> 00:09:19,880
France on think this

142
00:09:19,879 --> 00:09:24,549
Royce 576

143
00:09:24,549 --> 00:09:31,458
ice months of 10 percent discount yes I 5184 use 576

144
00:09:31,458 --> 00:09:34,679
-67

145
00:09:34,679 --> 00:09:38,479
725

146
00:09:38,480 --> 00:09:41,639
a 67-60 Essex 25

147
00:09:41,639 --> 00:09:45,149
use $25 plus 50 CSS cracked okay

148
00:09:45,149 --> 00:09:48,799
cool and many struck another

149
00:09:48,799 --> 00:09:52,490
subtotal in

150
00:09:52,490 --> 00:09:55,669
and this one's going to be total

151
00:09:55,669 --> 00:09:59,299
paid to go here

152
00:09:59,299 --> 00:10:06,299
now I ganar suggest you just wrote this for me

153
00:10:10,789 --> 00:10:15,579
I work in their for that now where D some men

154
00:10:15,580 --> 00:10:19,920
amount you're the but I D love multiplier

155
00:10:19,919 --> 00:10:24,149
equal one to taxi means we're now total in the payments mates

156
00:10:24,149 --> 00:10:28,169
press OK see what we get 1 for 10

157
00:10:28,169 --> 00:10:33,139
payment I'm

158
00:10:33,139 --> 00:10:39,009
payment no time

159
00:10:39,009 --> 00:10:42,909
thankfully for us 412 4013

160
00:10:42,909 --> 00:10:46,449
yes correct on for 10 K former and

161
00:10:46,450 --> 00:10:50,350
currency and the lost thing that's gonna leave

162
00:10:50,350 --> 00:10:55,180
as balance outside let's take this

163
00:10:55,179 --> 00:10:58,799
and name it text total

164
00:10:58,799 --> 00:11:02,679
and let's take this

165
00:11:02,679 --> 00:11:05,739
and you name it txt total

166
00:11:05,740 --> 00:11:12,740
pay gonna Party Rock

167
00:11:13,539 --> 00:11:17,289
commands alone Americans

168
00:11:17,289 --> 00:11:22,139
good design job from soon trip

169
00:11:22,139 --> 00:11:27,439
cool balance she's going to

170
00:11:27,440 --> 00:11:32,360
equal she's paid a thousand

171
00:11:32,360 --> 00:11:35,509
if you paid $1000 and the cost is 1500

172
00:11:35,509 --> 00:11:38,539
balance should be -0500 test text

173
00:11:38,539 --> 00:11:43,419
total paid minus txt

174
00:11:43,419 --> 00:11:48,708
tote so I make that

175
00:11:48,708 --> 00:11:50,649
she's 891 yep that's correct

176
00:11:50,649 --> 00:11:54,039
and former a a

177
00:11:54,039 --> 00:11:57,120
currency okay and

178
00:11:57,120 --> 00:12:01,539
personal control bomb click on all northeast to go to border-style:

179
00:12:01,539 --> 00:12:06,019
transparent for Nash ago

180
00:12:06,019 --> 00:12:11,308
some class sup Susan Connie save it do print preview

181
00:12:11,308 --> 00:12:14,528
me

182
00:12:14,528 --> 00:12:18,558
so we get some totaling

183
00:12:18,558 --> 00:12:23,129
information which is pretty cool okay so that's that's for the totals

184
00:12:23,129 --> 00:12:29,159
a one last thing I wanna do was that close that was yummy go here

185
00:12:29,159 --> 00:12:32,499
on a per ha maybe I'm oversized t

186
00:12:32,499 --> 00:12:36,308
auditor column it says print for invoice

187
00:12:36,308 --> 00:12:41,370
undisclosed main go find clearly she knows Creary

188
00:12:41,370 --> 00:12:44,999
invoices extended yes please go to design view

189
00:12:44,999 --> 00:12:48,028
take on here docents

190
00:12:48,028 --> 00:12:51,188
column became the top builder

191
00:12:51,188 --> 00:12:54,909
and school prin and for in

192
00:12:54,909 --> 00:12:58,100
needs to be in quotation marks

193
00:12:58,100 --> 00:13:01,949
okay expressed DS here

194
00:13:01,948 --> 00:13:05,078
for members extended DS

195
00:13:05,078 --> 00:13:10,049
to design view ok to design

196
00:13:10,049 --> 00:13:13,179
existed shoe its friend is in there

197
00:13:13,179 --> 00:13:16,659
my notes

198
00:13:16,659 --> 00:13:20,649
from signature save and close to us trying it again

199
00:13:20,649 --> 00:13:24,429
design go

200
00:13:24,429 --> 00:13:28,508
to use existing showing up for nasa structure in at the top

201
00:13:28,509 --> 00:13:33,058
today she view should be moved away

202
00:13:33,058 --> 00:13:38,028
night visited it hands up if you see print and others

203
00:13:38,028 --> 00:13:41,379
cheney packard

204
00:13:41,379 --> 00:13:44,889
for splice hyperlink always

205
00:13:44,889 --> 00:13:50,139
and on click Acree builder

206
00:13:50,139 --> 00:13:53,289
we're gonna say open for forename

207
00:13:53,289 --> 00:13:57,539
is for invoices where equals

208
00:13:57,539 --> 00:14:00,919
in Voice

209
00:14:00,919 --> 00:14:04,620
alrighty equals ampersand

210
00:14:04,620 --> 00:14:09,928
my voice I D checked lines that Owen

211
00:14:09,928 --> 00:14:15,110
as you make a print preview said a report saved acts like

212
00:14:15,110 --> 00:14:19,778
not that they should use already in Amiga

213
00:14:19,778 --> 00:14:23,448
first number two and fitness one

214
00:14:23,448 --> 00:14:26,719
again with someone okay full

215
00:14:26,720 --> 00:14:30,839
accept any series 10 video miniseries on invoicing

216
00:14:30,839 --> 00:14:33,850
done a as escaped my attention that the

217
00:14:33,850 --> 00:14:37,769
invoices are nonsense because the on balance please feel free to

218
00:14:37,769 --> 00:14:41,818
add and remove payments to your heart's content to make them balanced

219
00:14:41,818 --> 00:14:46,308
an and that's pretty much it for the invoice inside already really just

220
00:14:46,308 --> 00:14:46,969
wanting

221
00:14:46,970 --> 00:14:51,720
to you do have to database which is to make that is a continuous form that we

222
00:14:51,720 --> 00:14:52,798
can use condoms

223
00:14:52,798 --> 00:14:57,169
a.m. visual representation golf tee bookings in the rooms

224
00:14:57,169 --> 00:15:02,588
for or counselor annex she video so just another show many cities estimate on

225
00:15:02,589 --> 00:15:06,059
okay thank you for watching save all that and see you next year