Query : Matching 2 Fields from Table 1 to 2 fields from Table 2

[annemrosenberg]

Table 1 has a text field and a date field

Table 2 has a text field and a date field

I need to be able to see what text/date records matches between the two tables.

Please help!!!!!!!

Thanks,
Anne

[ajetrumpet]

I already solved this, my dear.

what was the additional question you asked? I forget, and I do apologize for not getting back to that thread.

[annemrosenberg]

Hi Adam,

I need the query to find matches if there is a Pathrow and date record in table 1 which matches a Pathrow and date record in table two.

Is that what you did?

I'm beginning to confuse myself.

[annemrosenberg]

I need it to not only show the pathrow field in the query but also the accompanying date as well.

[annemrosenberg]

Nevermind I got it!

[annemrosenberg]

ok So here's the real question and this may make absolutely no sense...but here it goes anyway.

I have a form that when you put in the starting pathrow to an end pathrow, you press a command button and it plots a bubble graph in a subform. Each bubble represents a pathrow with respect to a date.

What is being asked of me is this:

When there is a pathrow and date image from the archive table which matches a pathrow date from our inhouse archive (hence our fun query you helped me with), there needs to be a an object of some sort placed in that bubble to show that we have a match.

Gosh I hope that made any sense.

[annemrosenberg]

and by object I mean any kind of symbology ( a bold red plus sign has been requested)

[ajetrumpet]

since you posted a billion sentences since I responded, here's the stuff I'll cover:

ok So here's the real question and this may make absolutely no sense...but here it goes anyway.

I have a form that when you put in the starting pathrow to an end pathrow, you press a command button and it plots a bubble graph in a subform. Each bubble represents a pathrow with respect to a date.

What is being asked of me is this:

When there is a pathrow and date image from the archive table which matches a pathrow date from our inhouse archive (hence our fun query you helped me with), there needs to be a an object of some sort placed in that bubble to show that we have a match.

Gosh I hope that made any sense.

You can't really ask this on an access forum for 2 reasons:

1) No one knows what your 'bubble chart' is or where it came from, and
2) if the 'bubble chart' is not something that can be made from access's internal resources, you probably won't get much help on a forum because a lot of people that are here use traditional resources that the program only gives by default.

I may be able to help, but only if I know what a 'bubble chart' is. Reading that doesn't make any sense to me. Don't know of anything access provides that's even close to it. However, your setup (as you describe it now) sounds more or less like a glorified/flashy variation of a pivot chart.

[annemrosenberg]

Ok fair enough. It's one of the chart options within access.

[annemrosenberg]

its just one of the graphical ways of plotting data, just as a bar graph or line graph is.

[ajetrumpet]

its just one of the graphical ways of plotting data, just as a bar graph or line graph is.

ok then. shows how much I work with charts and graphs, doesn't it?

I don't think you can do it. and the reason why is simple: Those charts and graphs are not stand-alone entities. They're representations of data, just like tables are. The look is different, that's all.

So I think the answer is no, because of that reason. I can't even think of a work around, because you're asking to make some sort of noticeable change to the actual plot points. And while you CAN manipulate those actual points on graphs in some programs by way of object properties/property sheets (as in Access), all you can really do there is change colors/shapes/etc of the plot points. So integrating a query statement into it would be impossible.

And what I just said doesn't (I don't think) apply to actual chart transformations/interfaces (like bubble charts) of data. It only applies to chart OBJECTS, like the ones you see in design view of forms and reports. When you make one of those manually, that's when you have access to the properties that could help out here.

And another option might be to make 2 graphs, (one on top of the other?), one for your original dataset and the other for the query I wrote for you last week...the one that shows which records are in both datasets.

That's a start. To be honest, I've always hated pivot charts, and it's a known fact that the chart object/wizard in Access was designed in an incompetent manner. It's tough to use, and the wizard is extremely inconsistent and misleading. It's a chore just to even learn how to use it. I've never found any helpful MS information on it. It's one of those things I think that MS just blew off the table and quit caring about, so developers had to learn from each other. You can find good articles on that stuff, but they are few and far between even when you use google.

[annemrosenberg]

Thank you! I got it to work!