lothos12345
Well-known member
I want to print out an Access report using VB.NET. I have the program working except for an error that I keep getting in subquery that I am trying to feed the report. The error is as follows:
"You have written a subquery that can return more than one field without using the EXISTS reserved word in the main querys FROM clause. Revise the SELECT statement of the subquery to request only one field"
I am not quite sure what to do. My query is as follows:
"SELECT * FROM FloorOpps WHERE FloorOpps.DateEntry = " & Dateholder & ""
Any help with this would be greatly appreciated.
"You have written a subquery that can return more than one field without using the EXISTS reserved word in the main querys FROM clause. Revise the SELECT statement of the subquery to request only one field"
I am not quite sure what to do. My query is as follows:
"SELECT * FROM FloorOpps WHERE FloorOpps.DateEntry = " & Dateholder & ""
Any help with this would be greatly appreciated.