Complete newb: Query help needed

[Sven]

Hello all, new to the site and (due to changes at work) new to Access and in need of some expert perspective. Hooray for the new economy!

I am building a very primitive db to house resource forecasts. I have a basic table structure now and am looking to run a query (and subsequently base reports off these queries).

Here are my specifics:

Table A: Resource Forecasts
Fields: Resource Name (related to Table B)
Job ID (related to Table C [not involved in this query])
August Hours

Table B: Resource Details
Fields: Hourly Rate

Query goal:
To show all forecasts that have hours predicted for August, detailing the resources' names and their rates (for calculating spend)

So building my query, i thought i had it correct. Created the join, detailed the fields I wanted and how to filter. The problem comes in that it will NOT pull over the Hourly rate from Table B.

Here is the SQL out of Access:
SELECT [Resource Forecasts].[Resource Name], [Resource Forecasts].[Clarity ID], [Resource Forecasts].[October 2011], Resources.[Hourly Rate]
FROM Resources RIGHT JOIN [Resource Forecasts] ON Resources.[Resource Name] = [Resource Forecasts].[Resource Name]
WHERE ((([Resource Forecasts].[October 2011]) Is Not Null))
ORDER BY [Resource Forecasts].[Resource Name];


Any help would be GREATLY appreciated, I know I am just doing some very basic thing wrong that is stupidly easy to correct.

[June7]

Need clarification. You want August hours but filter is on field called October 2011 (not shown in the schema although August Hours is). You are joining with table called Resources but your schema is Resource Details and Resource Name does not show as a field in this table.

That you have fields named for months indicates tables are not normalized.

Provide sample data in a post or attach file (Access project or Excel spreadsheet).

BTW, advise not to include spaces in names.