[jrh]

I am just really learning Access 97 and am having problems w/ a query that I am trying to run.

I have two tables that I am trying to run a query on.
The first table is a log from the server, which shows the user's ID, video ID accessed, log-in time, log-out time, and total time.
The second table is a video table, which expands upon the video ID to show the title of the video, presenter and total time of the video.

I am trying to generate a query that will run through the server log, looking at each row, specifically pulling out the user ID and total time WHEN a match is seen with the video ID and total time (that is stored in the video table).

I have tried several formats and get different info with the run of each query. I have obviously not written the query correctly.

HELP! Please...

[downwitchyobadself]

Hi JR, welcome.

The quick answer to what you're doing is to add the two tables in the query design window (aka QBE), draw a join by clicking and dragging from the VideoID field in the first table (let's call it tblUserVid) list, to the VideoID field in the second table (tblVid, I'll call it), where you release, thus creating what's called an "inner join." (You should see a black line between the two.) This will return only related records between the two tables. Then, you need to set your criteria for the time part. Let's say you add the TotalTime field (whatever you've called it) from tblVid as a field to show. In the same column, on the line marked "criteria", you should put in the following:

=[tblUserVid].[TotalUserTime]

where, obviously, you use your table/field names and not mine.

For more intro stuff on queries in this forum, try this thread:

http://forums.techguy.org/showthread.php?threadid=41394

And if all this still sounds like Greek, well, post back and we'll clear it up. Best of luck.

[jrh]

Thanks for the quick response and great tips - downwitchyobadself!!

Wish I had been quicker to pop my mail and see your tip. I actually determined the 'make-table' was not the way to go and I didn't want to use a parameter. So, deleted and started over. Finally got my query working around 2:30 p.m. today. Think it would have been much sooner had I logged back in and seen your reply.

Thank you very much for the advice. I plan to keep your tip and the link that you referenced for any other problems I have with other queries I write!

Awesome response time!!