Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-18-2018, 06:26 PM   #1
azrak1201
Newly Registered User
 
Join Date: May 2018
Posts: 1
Thanks: 2
Thanked 0 Times in 0 Posts
azrak1201 is on a distinguished road
VLOOKUp

Hi guys, can i do a process in access 2010 similar to the vlookup in excel? not in forms but across fields. say for example i have a field in [MineExUG] that has [Eqpt_Numb], and that field is connected to a value in the [LookUpTable] table with the matching [Eqpt_Numb] in the lookup table. i know how to do an update query to fill in the values but what i want to do is to do it automatically when a new value comes on for the new row. i hope my question is straightforward and i hope hope for a reply. thank you guys!

azrak1201 is offline   Reply With Quote
Old 05-18-2018, 06:34 PM   #2
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,917
Thanks: 420
Thanked 277 Times in 243 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: VLOOKUp

If I understand you correctly, you want to populate fields in one table that already exist in another (lookup) table if the match a common value.

Assuming that is correct, this is not how data is stored in a properly structured Database.
__________________
- Ciao, John
NauticalGent is online now   Reply With Quote
The Following User Says Thank You to NauticalGent For This Useful Post:
azrak1201 (05-18-2018)
Old 05-18-2018, 06:35 PM   #3
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,020
Thanks: 64
Thanked 2,554 Times in 2,451 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: VLOOKUp

You need to manually select it from the combo unless you set the Default value.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
azrak1201 (05-18-2018)
Old 05-20-2018, 02:02 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,982
Thanks: 13
Thanked 1,538 Times in 1,463 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: VLOOKUp

There is normally no need to store the lookup value. Whenever you need to see it, base your form or report on a query that joins the main table to the lookup table. Use a left join if the lookup field is optional rather than required.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup thedeadzeds Queries 1 05-22-2015 03:42 AM
Trying to use a vlookup laxster Excel 4 06-03-2010 04:49 AM
Vlookup santoshdream Excel 9 06-13-2009 09:02 AM
vlookup eran185 General 6 09-25-2007 12:35 AM
Vlookup help scottappleford Excel 1 07-28-2006 07:00 AM




All times are GMT -8. The time now is 07:32 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World