Search results for query: *

I have a column based on a group in sharepoint that has 5 users in it. It previously had 10. The dropdown is showing all 10 users even though they are no longer part of Sharepoint site anymore. How can i sync these up? I am new to this so any advice you can help me with woud be greatly...

It will pull back the first line of criteria back correctly, however, if the first date({EscrowReconLoanBillingTask.OpenDate}) is null then it wont move to the second line. I have tried adding if statements/or isnull and nothing seems to be working. I appreciate any help you can provide...

Any or all of these values can be null or in another date range. If any of them are in my parameter date range i want it to show on my report.

Im sorry i forgot to put in the statement Im using: minimum({?Enter Date Range}) to maximum({?Enter Date Range}) ={Tasks.dbo_EscrowReconLoanBillingTask.OpenDate} or minimum({?Enter Date Range}) to maximum({?Enter Date Range}) ={Tasks.dbo_EscrowReconLoanBillingTask.ClosedDate} or...

Im putting this in the record selection. By pull back i mean query.

I dont know why im having such a problem with this: Using CRv10 Im trying to pull back if any of these three fields (dates): EscrowReconLoanBillingTask.OpenDate, EscrowReconLoanBillingTask.ClosedDate, EscrowReconLoanDisbursementTask.OpenDate are in my Parameter date range. Does this need...

I have three fields fico1, fico2, fico3 I want the median value of these three fields. If fico1 =600 fico2=700 and fico3=675 i would want to return 675 in a formula. I am using cr10, and for the life of me cannot figure this out, im sure it is super simple. I found where this can be done in...

Hi, Im new to VBA and im trying to compare by columns in excel and shade those that are different. I have column B and C that are supposed to be the same but if they are different i want to highlight them. The same goes for D and E, F and G etc.. This goes on for 200 columns so you can see...

Hi Everyone! Im new to Access and VBA and am trying to create an IF statement in a module to call in a query and IM getting a "Compile Error: External Name not defined" error. Im using Access 2003 and following is my module entry that im attempting to call: Public Function status() As String...

I have used Access 2000 to screen scrape data to and from an Attachmate client. However, the company no longer uses Attachmate and instead uses Rumba as their mainframe emulator. The methods that I used for Attachmate will not work to communicate with Rumba. I tried to search for online...

I am trying to capture this data in a crosstab report. Im not sure if you can do this or not, but I not only want the count of each column but also the percentage of the grand total that column represents. I can do this in Crystal and Excel, but I am having a hard time figuring this out in...

I have a report that is grouped by branch. We have 116 branches, and at anytime data can be populated for 1 or all of the branches. Each branch needs their own report. I have a macro that runs all of my daily reports and outputs them to a snapshot and I really dont want to have to add all 116...

There are 70 pages in this document. Is there anyway for it to look at either a keyword, or the branch header to designate this as its separate file?

I have a report that i create in access and export to pdf that is grouped by branches. Once i get it to pdf i want to extract each branch as its own separate file. Is there any way to do this. I dont know anything about acrobat. I really would appreciate any assistance you can give me...

I was hoping someone could help me with this. Im using Access 2000 and I am new to Access. Im doing an iif statement within a query. Expr6: IIf([expr5]=1,'Registered',IIf([expr5]=3,'Submitted'),iif([expr5] = 6,'LOI Executed') of course this is coming back an error. it wasnt coming back an...

IM sorry, I guess i didnt know what you were looking for. I have a simple cross tab: Q1 Q2 Q3 Total 3cmt 8 2 1 11 5cmt 2 2 3 7 7cmt 1 1 1 3 What I need it to look like is Q1 Q2 Q3 Total...

Yes, I want to know what percentage this value is of the total. IN excel this is called % of column.

Hello all: Im new to Access and was hoping someone could help me with this. I need to do a % of column (as in an excel pivot table) in an Access Cross tab. Can this be done? Thanks, KIM

Hi, Im using an Oracle db. Hope that helps.

I am trying to convert a report from Crystal to SQL and the Show SQL statement is not converting all of the criteria over and I was hoping someone could help: IN my criteria box: (not isnull({LOAN_USER.SECURITY_REC_SENT_TO_INV})or not isnull({LOAN_USER.FINAL_TITLE_SENT_TO_INV})) and...