Search results

Hopefully I can explain this well. I have linked 2 items from 2 tables. Amount and Invoice #. I then plan to have another column to bring back a Name. It looks like this. Journal Table Amount | Description | Date | AP (Yes or No) | etc (the Description contains an Invoice number if the...

Great, that worked. Thanks a lot everyone, especially HighTechCoach, the join properties is what i forgot about. boblarson, I figured there was something wrong with the link between the 2 id's but it happened auto when i added the tables, so just left it. Thanks again.

Okay, I'm not getting the exact result I was looking for. Can you take a look at the attachement? I am only getting 1 result as apposed to seeing all. Thanks.

The thing is, I do not want to list all the states. Is there some wildcard I can use in either my table or my query to represent any states not listed. What if I am only interested in specifing the region for certain states, i do not want to list the region for other states. Thanks for you...

Hello. I need help referencing 2 tables. Here is what I am trying to achieve. Lets say I have one large table with data such as: NY, NJ, PA, CA, WA, IL Then I have another table that I want to reference, so it would have: NY - East Coast, NJ - East Coast, PA - East Cost, CA - West Cost, WA -...