how local taxes 2013
you to roost over the next couple videos on going to be tempting to create
a saw remotely purpose clearly that we can use as the basis
a reports and also as the basis
pov form and simulate booking details
now known as do something in the eighties Cup live different
I'm techniques a couple different functions in this video I'm going to
explaining to you that the lookup function and how you can use that
in a query so if you wanna play along follow the link below the video to
download section a website
and download axis 2013 the B-fifty
and then we open at 10 okay so when I'm
interested in is if we take a look at
table booking details it is are we keep
most useful information about a
booking details fun enough including the check in date the check out today
the room gonna see some notes and we're gonna be
Krenek we reduce kinda base for for this
I am dude bit by bit so
like I said this particular video really folks in with the look of function
so if you go to the crate to and click on
query designed and for a moment just pick
I am table booking details and had
earned weekend
the worst had cool information
so what we've done is this replicate the original table what I wanted to
companies at the lookup function for this is owen a column
that indicates the cost per night over
and the couple ways to do this I could actually just drop
the room table in there used to cost for not then but then I wouldn't get
show you the the lookup function so it's no good is it
so what we do have I'm
is a room I T which is here in my tsk and want to do is use for a mighty
to go over to the room table terror group
and to look up the cost per night for that particular very mighty
that's why I wanted to and we use that the lookup function to do that
so weeks go from here
week lookin to this empty column computer
and what we're gonna call this column will call it cost
per night one perk kolam
so is going to be the name it up to column and now this is gonna be
the date is gonna hold and d
lookup click on to the Diva Cup function takes
to required documents and one optional argument the first acquired argument is
I what food we looking for and I don't remember close-up
usually this open actually so the food we want to actually returnees
cool crisp Annika probably guest up to why take a chance a
okay so it will cost per night so it needs to be within
open/closed quotation marks and also it's a good idea to prove an open and
close square brackets
so it looks like this going so that filled return it
the next than we did comma we say
where it's coming from this could be the name of a table or query
this case you're just interested in Table rooms and now we get to the
optional part which is where we specify some kind of criteria
criteria is
the room I T past equal whatever the room I T
returned by remote the FKS now on every single record
the I'm gonna run this for today she viewing please ignore sin
you know that one second for single record here
I'm we have a different well not for
everything recover from brick want to have a different room it. so remove work
on the cost per night
we wanna work out based on this for a mighty and he wanna work out based on
this for my day
through B-two's we go back to that the lookup function
with another common and
open/closed quotation marks I've per square brackets
and its room ID equals
now for an e-zine ampersand
and room here
to okay room high-t_
FK should actually be ok too close for practice anyway
okay the press OK and get it to run it speak now we get the different
cost per night the Sun explain that last bit too
we've actually done is remind the FK
refers to this field here remind TFK
so if for example within the record that's number one religious a
look up the cost per nine table rooms where the room I T
his number one and if that's number two say
look up the cost for nine table rooms where a mighty his number two
so that's the hook up funk is one other thing we can't do
because at the moment is returning a number not like it to return
like a currency we can actually convert this
to currency by happen in the SEC
you are market and that means convert currency
anything we've been CC you are practice will be converted to a currency
and we end up with that okay we'll save this will call this
I am query and I'm
booking the to whose X
then the press OK and I we got
Thank You fortunate enough to see you next video