1
00:00:01,209 --> 00:00:03,399
a lot of taxes 2013 shoot or ooze

2
00:00:03,399 --> 00:00:06,990
this video is a continuation all

3
00:00:06,990 --> 00:00:10,669
the shades form making

4
00:00:10,669 --> 00:00:15,509
a.m. and going to be showing you how you going to have to click on

5
00:00:15,509 --> 00:00:19,000
text books and open up a.m.

6
00:00:19,000 --> 00:00:22,948
related looking I Russia 30

7
00:00:22,949 --> 00:00:29,949
so come back says 20 searching DB 61

8
00:00:33,058 --> 00:00:35,049
which is a huge right

9
00:00:35,049 --> 00:00:38,820
and sure where you can go to them a section website

10
00:00:38,820 --> 00:00:42,399
and download this database

11
00:00:42,399 --> 00:00:45,530
follow the link below the video okie dokies

12
00:00:45,530 --> 00:00:49,100
I'm interested in this we are interested however in storm

13
00:00:49,100 --> 00:00:52,780
shoulda and as you can see

14
00:00:52,780 --> 00:00:57,770
scroll to the bottom where the actual conditions for matching works

15
00:00:57,770 --> 00:01:01,090
ministry dozen given the game later

16
00:01:01,090 --> 00:01:04,698
okay yet where the conditional formatting works to rezone

17
00:01:04,698 --> 00:01:08,349
here we're gonna be reduced click on the name this

18
00:01:08,349 --> 00:01:11,699
existing same room 502 on the 17 October

19
00:01:11,700 --> 00:01:15,530
j'mens 9 a.m. we want to bring up the related booking

20
00:01:15,530 --> 00:01:19,969
and if you click in a square doesn't have

21
00:01:19,969 --> 00:01:23,149
a booking I would like to open up

22
00:01:23,149 --> 00:01:26,509
the I am same form

23
00:01:26,509 --> 00:01:31,368
in data entry much region had a record works like this

24
00:01:31,368 --> 00:01:37,509
welcome jameson ok James merchant who happens to be in three different rooms

25
00:01:37,509 --> 00:01:41,118
the same time debts

26
00:01:41,118 --> 00:01:44,439
his wasn't paying much attention to the data

27
00:01:44,439 --> 00:01:47,618
but I'm gonna okay %uh so

28
00:01:47,618 --> 00:01:50,950
past that and then shark in a square

29
00:01:50,950 --> 00:01:55,090
awareness no person staying

30
00:01:55,090 --> 00:01:59,079
we get this bookings for Mike not so how do we

31
00:01:59,079 --> 00:02:04,000
due to actually mister the design do this to one of those things

32
00:02:04,000 --> 00:02:09,469
even due to us become negative range select Road

33
00:02:09,469 --> 00:02:13,199
and missus

34
00:02:13,199 --> 00:02:16,219
change but I just go to is hutch

35
00:02:16,219 --> 00:02:20,299
link display cycling always

36
00:02:20,299 --> 00:02:23,299
as like the most

37
00:02:23,299 --> 00:02:27,209
incredible changed makes a database issue to light

38
00:02:27,209 --> 00:02:30,729
the nice hanting okay so how do we do that strip

39
00:02:30,729 --> 00:02:35,189
to their square vents on this list

40
00:02:35,189 --> 00:02:38,329
macro based even okay

41
00:02:38,329 --> 00:02:42,230
and his how it works I am person when each do

42
00:02:42,229 --> 00:02:47,418
is find out what looking ID's so we September variable

43
00:02:47,419 --> 00:02:51,040
temp looking I T and then this is where we use a deal Cup function

44
00:02:51,039 --> 00:02:54,668
arkansan do market since

45
00:02:54,669 --> 00:02:58,660
and the Diva Cup function is looking up

46
00:02:58,659 --> 00:03:02,129
booking ID in query bookings explode

47
00:03:02,129 --> 00:03:05,430
where the room I G equals a mighty so

48
00:03:05,430 --> 00:03:08,989
that would depend on the particular recorder in and the day

49
00:03:08,989 --> 00:03:13,269
will be temp stopped a plus

50
00:03:13,269 --> 00:03:17,709
in this case is 0 kisses first rose records

51
00:03:17,709 --> 00:03:20,930
com records I should say the second column

52
00:03:20,930 --> 00:03:25,939
will be sub-zero one just

53
00:03:25,939 --> 00:03:29,579
news

54
00:03:29,580 --> 00:03:33,080
J so show usually it does very specifically

55
00:03:33,080 --> 00:03:40,080
looks of here the

56
00:03:41,449 --> 00:03:44,459
necessary dates in here so

57
00:03:44,460 --> 00:03:49,189
bases in LNG day say look up to date resume for sure

58
00:03:49,189 --> 00:03:52,300
1563 lookup room I T

59
00:03:52,300 --> 00:03:55,969
which is here and she finds it

60
00:03:55,969 --> 00:03:59,530
return the key ID I'll let you ever play around

61
00:03:59,530 --> 00:04:03,069
booking left dude

62
00:04:03,069 --> 00:04:07,840
function and next column we have to sing sing

63
00:04:07,840 --> 00:04:11,110
we have one so once actually found the booking

64
00:04:11,110 --> 00:04:14,500
ok so obviously I should mention

65
00:04:14,500 --> 00:04:19,480
yeah we're looking at the booking if he doesn't find the fucking

66
00:04:19,480 --> 00:04:23,980
we I like seeing an old value back we don't really like to do in nobody's

67
00:04:23,980 --> 00:04:28,069
so views the ends at function and then dysfunction works to

68
00:04:28,069 --> 00:04:32,459
whenever you put in the first part which is the dealer cops are returns now you

69
00:04:32,459 --> 00:04:33,419
get to determine

70
00:04:33,420 --> 00:04:37,580
new value shot decided return -1

71
00:04:37,579 --> 00:04:41,419
so dished embossed him back in ninety straighten 0

72
00:04:41,420 --> 00:04:44,689
which means its return to action booking ID not -1

73
00:04:44,689 --> 00:04:47,779
open up for bookings data entry in

74
00:04:47,779 --> 00:04:51,819
user simple where conditions go to the random bookings otherwise we're gonna

75
00:04:51,819 --> 00:04:57,279
saying form but it's going to be in admired okay so that's the general idea

76
00:04:57,279 --> 00:05:00,419
a.m. definitely download image take a look at it

77
00:05:00,420 --> 00:05:04,350
this particular function make sure you understand how this works

78
00:05:04,350 --> 00:05:08,379
and to United

79
00:05:08,379 --> 00:05:11,930
so free to change around break it you can always redownload database

80
00:05:11,930 --> 00:05:16,750
tissue can get it amazing things a.m. denouncing

81
00:05:16,750 --> 00:05:20,980
pot make for me muscle at nine tonga

82
00:05:20,980 --> 00:05:24,790
by then everything worth mentioning is pie using

83
00:05:24,790 --> 00:05:28,580
see long past

84
00:05:28,579 --> 00:05:31,829
day speakers she goes very diffuse slow

85
00:05:31,829 --> 00:05:35,919
I tend to not like to do wish

86
00:05:35,920 --> 00:05:39,509
format it takes an access I find it causes too many problems

87
00:05:39,509 --> 00:05:45,099
because a not so much here is really a good record him if for example the fifty

88
00:05:45,100 --> 00:05:45,790
should attend

89
00:05:45,790 --> 00:05:48,860
2013 skidded shifting October that read

90
00:05:48,860 --> 00:05:53,550
the 10th the night fish the 10th 2013

91
00:05:53,550 --> 00:05:56,550
actually tends to interpret that as

92
00:05:56,550 --> 00:05:59,689
Saturday night October the 10 for September

93
00:05:59,689 --> 00:06:03,949
so why do is I like to use the actual stored value today

94
00:06:03,949 --> 00:06:08,668
which is a long integer here so full 1 562 is how

95
00:06:08,668 --> 00:06:11,810
access stores stay a.m.

96
00:06:11,810 --> 00:06:16,069
and wishes essentially for much version updates

97
00:06:16,069 --> 00:06:19,279
that's why was conveyed long into jazz and use that

98
00:06:19,279 --> 00:06:22,719
okay sis the video nothing major there

99
00:06:22,720 --> 00:06:27,330
but we marching towards finish in this form is almost complete an

100
00:06:27,329 --> 00:06:30,839
next video gonna be try to utilize these buttons to manipulate

101
00:06:30,839 --> 00:06:34,589
the dates thanks thank you for watching a senior next year