C
curley
I have a database in excel that we needed to add a matix to. I did th
matrix in access and ran a query through microsoft query. The quer
returns an ID tag that I need to reference to a database using vlookup
The vlookup is supposed to obtain all the information about the ID
Problem is excell seems to read the tag coming from the query differen
than I need it to. For instance it returns the number 136776......bu
will not pull the ID information, yet if I delete the reference to th
query and just type in 136776 it will work and pull all the informatio
I need. Any ideas on what I need to do?
(note: I have tried coverting the data all to text to ensure it i
reading the exact same info, but the program did not respond)
How the database works is there is drop boxes that are picked b
engineers and then an ID tag pops up. This takes place on one tabbe
page.....that Id tag is then transfered to a front page. The front pag
then automatically pulls out the ID tags description, the quatit
required and the routing. Now I can actually get the number(136776) t
transfer to the front page and it goes to the correct box, but exce
won't read it and give me the info required. Yet if I type the numbe
in the box, the same number, I get all my info required. For som
reason excel sees the queried number different than the typed? I a
stuck
matrix in access and ran a query through microsoft query. The quer
returns an ID tag that I need to reference to a database using vlookup
The vlookup is supposed to obtain all the information about the ID
Problem is excell seems to read the tag coming from the query differen
than I need it to. For instance it returns the number 136776......bu
will not pull the ID information, yet if I delete the reference to th
query and just type in 136776 it will work and pull all the informatio
I need. Any ideas on what I need to do?
(note: I have tried coverting the data all to text to ensure it i
reading the exact same info, but the program did not respond)
How the database works is there is drop boxes that are picked b
engineers and then an ID tag pops up. This takes place on one tabbe
page.....that Id tag is then transfered to a front page. The front pag
then automatically pulls out the ID tags description, the quatit
required and the routing. Now I can actually get the number(136776) t
transfer to the front page and it goes to the correct box, but exce
won't read it and give me the info required. Yet if I type the numbe
in the box, the same number, I get all my info required. For som
reason excel sees the queried number different than the typed? I a
stuck