Report wizard Error Message

[emilyebba]

Hi Please Help!!

I am getting an error message when trying to create a report.

Please see this thread link below. I am trying to create a report from a query I created to find out which customers in my database have not paid. I first create a query using the date parameters I am looking for, then the query compares my master customer list and the paid customer list to find out which people on the master list have not paid. This is the error message:

"The Wizard is unable to preview your report, possibly because another user has a source table open in exclusive mode. Your report will be opened in design view."

Then is creates a report in design view and when you click on it to open it you get this message:

"The Specified Field (the name of my table here) could refer to more then one table listed in the FROM clause of your SQL statement."

I am using my computer at home and nobody else is accessing it.

Thank you! Help!!

Here is the thread:
http://www.access-programmers.co.uk/forums/showthread.php?p=1197575

 

[emilyebba]

Everything is closed. I just rebooted my computer and opened up the database and tried to run the report. Same thing. How do I do the alias? Thank you!

 

[emilyebba]

Mr. Larson,

Mahakj2 wonderfully helped me with the query and posted a database on the thread I listed below. His database returns the same query wizard error. I thought it might help you understand whats going on with creating a report. His posted database is at 10/9/2012 at 5PM #13

http://www.access-programmers.co.uk/forums/showthread.php?t=234705

Thank you...

 

[emilyebba]

Oh wow. That worked! Thank you thank you 1000 times thank you!!! One last thing. How can I show on the report the date parameters I am using? It does not show this on the report? PayPeriodFrom and PayPeriod to. You enter it in in the criteria section but it does not show on the report. THANKS!!

 

[emilyebba]

The form will not be open because this will be a report run off the switchboard. The database will be set in a secure mode...i.e.users will not have access to anything other then what is on the switchboard.

 

[emilyebba]

Im confused. Of course. Bear with me. When you "run" the report it asks you for the date parameters...is the "form" open then at this point? I dont have a form created for this only a query?

 

[emilyebba]

I didnt make that form. I see what you are saying though. And I need to redesign how reports are opened. Thank you. Now...I see they are unbound text boxes. How are they linked to open the right data though? I created a new form and put two unbound text boxes but cant figure out how to run the query to open the report? Ahhh!

 

[emilyebba]

I just figured it out. My report works beautifully. You have been such a great help! THANK YOU!!!!!

 

[emilyebba]

Mr. Larson everything is working great as you suggested!!!!

Can you suggest some code to "put some code in the report's close event to close that date select form when the report closes." Thanks