My problem sounds very simple but is to say at least very perplexing.

I have a query based on 4 - 5 tables, that provides me with bookings/bilings/budgetary iinformation. I have replaced the FY04 budget table with FY05 table...but upon runnng the query get no info from the FY05 table.
The structures are identical.
The links are identical.

I have even copied and pasted the structure of the original table and updated it with the FY05 values, but it still doesn't work.
If I then replace with the old original table, the values are captured !!

Is this another little bug in Access or am I being completely blonde ?!

Not enough info. Have you created the relationships in the database, or are you creating them in the query? What are the linking fields?