HI All
I need some help
I am very new to Access so please be patient
I have two tables imported into access
Marketing
Lookup
I have started to build a query called “query1”. Query1, manipulates the “Marketing Table”. In my query i have the created the following
Column: Channel
Formula : IIf([Sub-Source] Is Null,[How did you hear of us],[Sub-Source])
I would like to create a look up from “Channel” To the lookup table
Within the LookupTable i have the following 3 columns
Id
Field1
Channel
The link between channel (column in the query) needs to be on field1, and returns “Channel” on the “Lookup Table”
Looking for some step by step guides
In excel i do this via a vlookup. (kinda looking for same logic but in access)
Would appreciate any help available