Query for Unpaid

[emilyebba]

Hi, I finally figured it out using your sample! Thanks!!! BUT....

Using this query in Design View I can run it no problem. But when I go to make a report using it I get the following 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."

What does this mean? There is nobody else on my computer as it is not hooked up to any network. There are no other users? Why would I be able to view the query in design view but not make any reports?

So it then creates a "report" but when you go to open it...you are unable to and 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.

Whats going on?

I might add that in the Unpaid Date Filter query for the date criteria (report period from/ and report period to) I used:

Between [Start Date] And [End Date]

and not as you said:

Between [forms]![frmSelectDate]![textfrom] And [forms]![frmselectdate]![textto]

I didnt understand that.

Please advise! Thanks!!

 

[emilyebba]

Hi Mahenkj2,

Can you try to create a report using the database you sent me? Your database gets the same error message that I am getting. Thanks.

 

[mahenkj2]

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.

You can see that in your record source there may be one or more field which may be present in a table as well as in query date filtered, so access confuses and so this alert. when you use report wizard observe carefully while selecting fields and possibly select those fields which are in qrynotpaid.

Between [Start Date] And [End Date]

and not as you said:

Between [forms]![frmSelectDate]![textfrom] And [forms]![frmselectdate]![textto]

both ways me correct to enter a parameter to run the query but in first case you would be given small pop up by access to enter Start and End Dates and you have to manually enter dates. In second case, you first enter dates comfortably dates in a custom form and then this form is referenced in access query.

I hope you practice as much as possible. Rest I will see tomorrow morning.

best regards.

 

[emilyebba]

Hi. Thank you! I posted the error message in the reports forum and got this reply:

http://www.access-programmers.co.uk/forums/showthread.php?p=1197794#post1197794 Using the alias worked. Thank you for helping me with this query! I appreciate it so much!

 

[mahenkj2]

Happy to help.

 

[syedadnan]

If you please look my matter please

Perhaps if you posted a sample of your database, it might be a little easier to understand. I am not understanding why you have two Payment Recieved Fields, the relationship of the fields in your table, etc. Do a compact and repair before uploading it.

Regards,

I need help .. say i have 3 tables one for student information second for Van information and third is payment.

I want to know how to get the list of students not paid based on specific month which need to mentioned may b through a form which also you need to guide me how. an urgent response will be highly apprecieted

a file is attched for ref