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
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,315
Thanks: 292
Thanked 168 Times in 148 Posts
NauticalGent will become famous soon enough NauticalGent will become famous soon enough
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.
__________________
...see, what had happened was...
NauticalGent is offline   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: 6,136
Thanks: 54
Thanked 1,968 Times in 1,881 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
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 offline   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,123
Thanks: 13
Thanked 1,350 Times in 1,286 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
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 08:40 AM.


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

Sponsored Links

How to advertise

Media Kit


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