understanding access queries

[scamper]

I am new to working with access 2007, but I have extensively used oracle, sql server, and nonstop sql relational database.
I am trying to understand several queries that call each other.
When I run some queries and load some data into the access 2007 database, the queries run correctly. However when I clear out the 'current month table' of 'now' what was the previous months data and run the query, nothing is selected. The highest level query has some hard coded dates in them. I went and changed the data ranges in the query and nothing is selected.
From what I have seen of the queries, they look like subqueries in the other databases.
Thus to solve my problem can you tell me what you would recommend to solve the problem?


1. Should I post the queries on this forum?
2. Is there a way to 'debug' the sql?
3. I do not believe any VBA code has been written. If there is VBA code that has been written, can you tell me how I would look for the VBA code?

[June7]

You can show query statements in post or attach the project.

Debug Access objects (tables, queries, forms, reports, macros) by exploring them when something goes wrong. Refer to link at bottom of my post for tutorial on VBA debug techniques.

Can you see the full ribbon and Navigation pane when you open the project? Click Database Tools > Visual Basic is one way to open the VBA editor.

[scamper]

thanks for your answer