a look taxes 2013 shoot or ooze
in this video we'll be talking to you about concatenation
social play-along follow the link below the video to Thomas ok to the website
and other taxes 2013
the B-seventeen and open that
one up with 2013
of course okie dokie
okay what we've been doing where we've been creating
query cookware you looking details extended we've used
in problem it is going to use the lookup function
to get the cost per night for the room and
lost video we used but they to function to get the duration
and before I get
and concatenation I want to go to work out the actual cost to the state
and across the state is obviously cost per night times duration:
so North worked out clicking here
this crap food cooked 02 poll on cost per night
times CS troops
duration: okay the rum
and we get that total to
which is kinda great now I
I'm gonna cleverness a little bit for do I want to point out one thing
quite important the two fields on basing this total of of
or themselves a kind of calculated fields
or maybe character it feels is not the right terminology but they're not foods
and native to the table we've got to work them out
using functions I'm and with more flight and together we've got the total
I am this works most the time
except and welcome to the rules just have a looker
around here its gonna at the Rose ground here not a control group
now for added a row so third one down cool total
i'm ok explain what these totals of suffice to say that
aggregations for field perm
so I didn't actually just explain that but if you try run this query now
won't work because it they were good workout cost per night
someone removed totals there is no mention that as I spent many a happy
hour banging my head against the wall trying to work out why
my filled up sometimes being
phil has sometimes been understood by AXA sometimes know and it's to do with
where the photos employees don't know just for the record if you wanted to
work out
cost per night will total
you have to actually take this expression here
and take this expression he did
and drop them into total I'm
tonight that's just a quick one on why the does it doesn't work sometimes
right now to the job in hand for his concatenation
well where want to do is on the Cray
for the field over here and I think I'm gonna call this field
a cost
because I can and I want the food to read something along the lines that this
so four nights 120 Pampa mike was formed in eighty
obviously I want this the change depending on the duration for record
I warm this number here to change depending
on the cost to the room and I want this to change
depending on the tosoh
but i wanna put together in one single filled
I have my reasons how do we do that row weekend
reference the fields over here by
growing cost per night duration: auto to in here but we're going to use a
technique called
concatenation to turn them into something the
speak and the hutu join the filter adding them
to make sense okay so the nameless foods gonna be our school it cost
to seize member and if you remember from our
2x four nights at 120 pound per night so the first thing is
the duration perform and then
North right nights fifties and ampersand never gonna post
a string variable nights to make treatise space
and nights space at
so we've got four remember adding on to the fore
or putting it together with the expression night
at we now need to have crossed the room 120 pound
and per
knowing
equals
and I'm total
hasn't quite worked out there because wouldn't say that
in total some say that and run an issue we care
occur so we're almost there we've got
cake so we got four nights at 120 for nine Eagles for eighty four nights on
250 per not equal 600
so what we're missing actually a two-pound science here and here
to take another quick look at what we've
dumb were taken afula a value from the field so for example duration: it was
for
with venues and ampersand and
added the expression nights at so we're not performing calculations that this of
key point with concatenation
not calculating the number one adding to the number for all
and to more dividing you hope motif like it
we're treating it as a character that we can see so you're saying for
were tacking on this expression nights
at when next taking another expression
cost per night to attack in that one on and then
another string variables per night equals and then
for expression which were attacking on so we're not perform any calculations on
these expressions religiously
creating a string that displays these expressions
in such a way that we can read a measly understand them
now in order to get the pound signs in just after the app
course and space and then you put hey
pound sign and in turn I
be cool space Council
okay press run gonorrhea for myself 120 pound per night because for 190 pound so
that's the idea of concatenation key points not for calculations it so you
can put
streams in variables together and display them in a way that sorta
meaningful to humans this
pretty much know they have to cut the nation's far as I see it
I'm so thanks for watching the video and
hopes in exon