I have my Crystal report linked up to an Access database on my C:. I am using Crystal Reports 9. There are about 20 tables linked up within the report. The report was refreshing fine until I added my final chart to the report template. When I try to refresh I now get the error message below...
I'm trying to run a query with a simple calculation.
[#Services]/[#Members]
Some of the results are returned with #Error
Is there a way for the result to return 0 and not #Error?
Thanks!
Is there a way to get back multiple results when using the Top Vaule property in a query? I am trying to get back the top 10 products sold for all salespeople in my table. The Top Value property works but it only returns the top 10 products for one salesperson. I am querying off a main table...
On an Access form, I have created a simple "FindRecord" command button that uses the Access FindRecord action to search for records. When the user clicks the command button, the search box is displayed, with defaults pre-set. I would like to know how to change the pre-set defaults. Here...
I have 10 Parameter Queries that require the user to input the same values when a macro is running. Is there something I can do to have the user enter the values only once and they will get fed to the other 9 queries running in the macro? Thanks!
I want to create a simple form that will be linked to a query. I want the form to open blank and when a user enters a name in the blank, it will pull all of the records based on the name and show the results in datasheet view. what is the easiest way to do this? Thanks!
Is there a way to change the font in a combo box in Excel 97? Also, how do you make the combo box smaller? Right now I have it to the smallest size that Excel lets me when I right click on it. It is still too big for the form I am creating. Thanks!
Is there a a way to have a combo box appear when you click in a cell in Excel? I can create a regular combo box where you see the drop down arrow all the time but would like to hide that and have the combo box choices appear when a user clicks within the specified cell. Is there a simple way...
Thanks Nice! I will get another query. Do you know why it doesn't work? I have another database where I have a query totaling another query and it works fine even though some of the results for the fields are blank. I just placed all of the final total queries into one main totals query and...
Golom - Below is the SQL for one of the totals query. Thanks!
SELECT Sum(COMPANY_NON_POS_INP.SumOfAMOUNT) AS SumOfSumOfAMOUNT
FROM COMPANY_NON_POS_INP
GROUP BY COMPANY_NON_POS_INP.XYZ, COMPANY_NON_POS_INP.BOB, COMPANY_NON_POS_INP.Product, COMPANY_NON_POS_INP.[Fund Code];
Golom - How would I incorporate the SUM(NZ([AmountField])) into the queries? The queries are totals queries that query another query to get the $$ amount. My totals query looks like this
Field: SumOfAMOUNT
Table: Recovery
Total: Sum
When I run it it gives me the $$ all rolled up into one...
I have a bunch of small queries that total dollar amounts up. I am trying to put all of the totals queries into one big query so I can create a report. It works fine for all of the queries that have a $$ amount in the total. When I add a query where the $$ amount is blank, the entire query...
Thanks guys! Andy - b) works great. But with a) when I tried to change the Control Source I received an error message on the form %Name. Currently in the Control Source property I have the name of the field which is Project Sponsor. The name of the table is Project_Sponsor. Any way to fix...
I have a combo box on a form that is made up from a table. When a user is in the form they can click the combo box and see a list of people. The combo box on the form will accept a new entry but when I look at the table, the new name isn't included. Can someone tell me the correct setting to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.