I'm curious, if I drop the use of crosstabs, what would the better alternative be? If you hard code the field names in query to force us, then the trade off is loose flexibility of crosstab as you hard coded. If you get to many fields in cross tab report it starts to break accros pages as goes beyond page width. That was my orignial plan. Each count by realtor and by agency office.
The main report was working great. As soon as I inserted the sub report is when the problems started. I'd prefer to go back to my original plan if possible -- data displayed vertically. I just am not sure of how to give them the format they're looking for If there are no parameters you probably have an alias or formula typed incorrectly using square brackets or a function typed incorrectly. Like was mentioned earlier look at all of your columns on both queries to see if anything is hinky.
That's what's strange. Both reports run great separately. When I insert the subreport, I get the prompt looking for one of the crosstab queries: "qryCrossDelivered". That is where most issues like this happen when you join a sub report or subquery. It is probably something so simple you will kick yourself.
How is the subreport joined to the main report? The reports are linked using Master Field [qryCrossDelivered. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox.
Newsletter Topics Select minimum 1 topic. Data Management. Tags: MS Access. Bruce VanOrder January 14, 0 Comments. Greetings, This is driving me loony!!! How can I remove this prompt? Any help will be greatly appreciated. Regards, Bruce V. Richard Nyanzi Posted January 14, 0 Comments. Hi, If this is a web application that displays the report in a browser, it is possible that the actual page that displays the report needs a URL parameter to be passed to it from the page where you run the report.
Regards, Jon Carter. Paulo Silva Posted January 14, 0 Comments. Hi, This message is automatic when your query has unknown fields. And the Winner is……………… Jon Carter…. When the form is opened, it prompts the user for the max date, then the user has to pick their name from a list, then it promts for the date again. Remember that spaces are significant. As I was thinking about this I figured it must be in the join. Title, Transaction. RetireeID, Transaction.
TransactionDate, Transaction. CreditAmount, Transaction. Can you reverse the process so that your form opens first and then the query is run? Put the date request on the form and then the query would use these values:. Based on the query you posted, if you are adding new transactions to the Transaction table, you should be using a query something like:.
I have had this problem when there is a sort in the query with the parameter in it. I fixed it by removing the sort from the query.
CreditAmount, [Transaction]. Note, Transaction. Make sure you have typed the name correctly, and try the operation again. Not sure what to make of this. I moved the columns around and at one time had the same error but with the CreditAmount field. Your query is creating a new record, using the contents of an existing record.
The existing record is not affected. As a result, you will have two records for the same transaction. In other words, you want to update the RetireeID field, while leaving all the other fields unchanged. All of this makes sense. I modified my queries and updated my forms, however my main form blew up.
I do not wish to rebuild this entire database.
0コメント