UPDATE [Linked Portfolio Report] INNER JOIN Hierarchy ON [Linked Portfolio Report].CC = Hierarchy.Businessunitid SET Hierarchy.[No notes] = [linked portfolio report].[# notes], Hierarchy.Balance = [linked portfolio report].[lgr balance];
My original post left out that this I am running Access...
I have an Microsoft Access update query that I run each month with no real issues. We download data from our mainframe (we are a bank) to excel. The excel worksheets are then used as linked tables to update parts of the access database.
The only problem is when something becomes blank...
Bug Found in CR
under "Report Options" uncheck "select distint records" and the whole memo field will display. No other changes made just unchecked this totally unrelated option for the report and CR displays the entire memo field.
I have several MEMO fields in my access database that are being truncated at 255 characters in Crystal reports. These are very long fields with data typed by users. We use them as reports to managment to show progress in problem loan resolution.
Field Explorer shows them as Memo fields. Can...
I need a form to always open with a certain filter applied rather than the last filter applied. I wrote the filter in advanced filter/sort and saved it as a query.
I have tried two methods to define the query as my filter. I used the Form Property Sheet and tried the <Advanced Filter/sort>...
Thanks Skip. Excel calculates left to right across the sheet, so the mixed reference is necessary.
I am reading up on Relative, mixed and absolute cell references.
Thanks Skip. I tried that even before your post after seeing the issue earlier today. It works, but why?
Forum Managers: The other conditional formating question from today did not show up on the search for "find a forum". Sorry for an almost duplicate post.
Changing the formula to:
=$C6:$C44="city name"
(with the relative refernce on the column only) worked. The conditionally format now affects the entire row.
But the question for the FAQ is WHY?
I am trying to conditionally format an entire row in Excel 2007. This used to be easy in 2003, but I cannot make it work in 2007. I am trying to change the color of an entire row based on the value of a cell in that row. My formatting formula looks like this:
Formula: =C6:C44="city name”...
Do you ever have the report run to show company a and b and c all in one report? Is so, would a group by company work to show them. then all of the logos could be put in the single group header and footer on top on one another and conditionally suppressed unless it matched the goupname you...
The field would "show" as a number in .csv and excel. You could sort or search the text field in csv or excel. You could not use it for calculations in Excel unless the user converted it, which seems plausible if they had the expertise to export the report from crystal. Anyway, wouldn't...
CORRECTION: I ran the table analyzer and performance analyzer last month. The delete query now points to a new query that access created for me to represent my old table. My append and update queries both point to this new query rather than the underlying table that access named table1...
CORRECTION: I ran the table analyzer and performance analyzer last month. The delete query now points to a new query that access created for me to represent my old table. My append and update queries both point to this new query rather than the underlying table that access named table1...
Could you convert it to a text string for display? Maybe a formula that declares it as a string rather than a number. Just don't use the tex string in any calculations for the report.
IF Blue Horizon's fix does not work, then edit the rule and be sure that "mark it as read" is NOT part of the rule. That is an option in the rules wizard.
I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...
I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...
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.