ravynfaire
New member
- Local time
- Today, 06:46
- Joined
- Nov 12, 2002
- Messages
- 9
Hello. I am having a problem with reports/queries. Here is the problem. I am trying to create a report from a query, just like I have done with all the other reports I have. For some reason this particular one is giving me a problem.
I have the query designed to look through my books table and pull information from the author section.
Like [Enter the first letter of Author] & "*"
I create the report in wizard (I have Access for XP) I pull the query search by Author. Pull the fields I want, fix the layout and finish.
Then when it trys to open it, it asks me to "Enter the first letter of Author" great that is what it does in the query. But when I click "Ok", it ask me for "Books.Book ID" .
I don't know where this is coming from since it does not ask me this in the query.
How can I get this to stop asking me for "Books.Book ID" and just look up what I have told it to?
Also, for some reason this one won't open on the switchboard that I have created. All the others do. PLEASE HELP!!!
I have the query designed to look through my books table and pull information from the author section.
Like [Enter the first letter of Author] & "*"
I create the report in wizard (I have Access for XP) I pull the query search by Author. Pull the fields I want, fix the layout and finish.
Then when it trys to open it, it asks me to "Enter the first letter of Author" great that is what it does in the query. But when I click "Ok", it ask me for "Books.Book ID" .
I don't know where this is coming from since it does not ask me this in the query.
How can I get this to stop asking me for "Books.Book ID" and just look up what I have told it to?
Also, for some reason this one won't open on the switchboard that I have created. All the others do. PLEASE HELP!!!