functions

  • Thread starter Thread starter abkad
  • Start date Start date
is there a function on database like lookup function on excel
Click to expand...

Excel is a spreadsheet.

Access is a relational database.

THEY ARE VERY DIFFERENT.

In *most* (not all) of the cases where you would use VLookUp in Excel, you
would not use any function at all in Access - you would instead use a Query
joining two tables.

Rather than asking "how do I make Access work as if it were Excel", perhaps
you should describe the information that you have, and what you are trying to
accomplish. It may be easier than you think.
 
Thank you everybody for help. I have table with "shop Drawing". In this table
column with name "Location" spicify Location of drawing on server. this
location depending on drawing name. Example : drawing name P1 its location on
server on podium 1 so want to make query that complete location of drawings
according to its name without needing to me to choose data
 
Thank you everybody for help. I have table with "shop Drawing". In this table
column with name "Location" spicify Location of drawing on server. this
location depending on drawing name. Example : drawing name P1 its location on
server on podium 1 so want to make query that complete location of drawings
according to its name without needing to me to choose data
Click to expand...

It sounds like you have one table (named [shop Drawing]) with a field named
Location. Do you have a table of Locations? You say "complete location of
drawings according to its name" - do you mean the name of the drawing or the
name of the location?

Either way you can create a Query based on your table. If you want to find all
of the drawings at a particular location, put the name of the location on the
Criteria line under the Location field. The query will now show you all of the
rows with that location. You can do the same with a criterion under the
drawing name, to show all locations for a drawing (just one location, I hope!)

You may want to read some of the introductory tutorials below. Coming into
Access from Excel can be confusing because tables look like spreadsheets - but
the total logical structure of the program is very different; you may need to
"unlearn" some of the things you're used to doing in Excel.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Thanks John. I mean name of drawings. I have table for locations. And no , I
don't have one location for all drawings. location of every drawing depending
on its name.
--
ab


John W. Vinson said:
Thank you everybody for help. I have table with "shop Drawing". In this table
column with name "Location" spicify Location of drawing on server. this
location depending on drawing name. Example : drawing name P1 its location on
server on podium 1 so want to make query that complete location of drawings
according to its name without needing to me to choose data
Click to expand...

It sounds like you have one table (named [shop Drawing]) with a field named
Location. Do you have a table of Locations? You say "complete location of
drawings according to its name" - do you mean the name of the drawing or the
name of the location?

Either way you can create a Query based on your table. If you want to find all
of the drawings at a particular location, put the name of the location on the
Criteria line under the Location field. The query will now show you all of the
rows with that location. You can do the same with a criterion under the
drawing name, to show all locations for a drawing (just one location, I hope!)

You may want to read some of the introductory tutorials below. Coming into
Access from Excel can be confusing because tables look like spreadsheets - but
the total logical structure of the program is very different; you may need to
"unlearn" some of the things you're used to doing in Excel.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
Click to expand...
 
Thanks John. I mean name of drawings. I have table for locations. And no , I
don't have one location for all drawings. location of every drawing depending
on its name.
Click to expand...

I'm sorry, I still can't visualize your database structure. Please post a
description in the form:

Tablename
Fieldname (datatype; Primary Key)
Fieldname (datatype)
Fieldname (datatype)

Tablename
Fieldname (datatype; Primary Key)
Fieldname (datatype)

etc. and indicate how the tables are related. If the significance of the field
is not obvious from its name, please post that too.
 
Back
Top