Search results for query: *

Hi Folks I need some help here. IIf( Price.[FileName] ="Price" and [SubmissionType]="Add", "467", IIf( Price.[FileName] ="Price" and [SubmissionType]="Change", "467", IIf( Price.[FileName] ="Rate" and [SubmissionType]="Add", "209", IIf( Price.[FileName] ="Rate" and [SubmissionType]="Change"...

Hi, Can someone guide me here please. I have two DB fields (SQL Server Query) : Title......Name Manager....John Pricer.....Smith Support....Mary IT.........Alex Now I need this to appear in my report as below, I mean as in 2 columns without headers. I tried setting this by going to: page...

Hi, Can someone guide me here please. I have two fields: Title......Name Manager....John Pricer.....Smith Support....Mary IT.........Alex Now I need this to appear in my report as below, I mean as in 2 columns without headers. I tried going to page setup-->Column-->GRID settings-->no of columns...

Hi, Can someone help me here. My report layout is DB field with some textboxes. The report needs to be exported to Excel format. In excel where the blank textboxes are, the user must be able to key in a 10 decimal value data. So I inserted a textbox in the detail section next to the Name...

Hi can someone help me here. Group Header: I have a group created called "Account" (each account has several funds)and suppressed. In detail Section I have fields FundName and Amount only 2 fields. Fund Name Amount Formatting Pattern AccountA 100 Top:Line, bottom: dotted AccountA 200...

Hi , can Someone help me understand this query. while I am trying to execute this query in the VB6 Code in Access, I am getting the following error- Too Few Parameters. Expected 1. Please help. RunSQL = "select * from (dbo_SOURCE_RUN_DATA) where rundate between (#" & start_dt & "#) and (#" &...

Hi, Can someone help me here, I have never used Access and I am working on my BA stuff that needs a sample mock up report for the business, where I need a form which gets data as a result of SQL query I created. But now I need to filter the data using 2 text boxes that I have on the form...

Hi can someone help me here. I have below outline in my report. In Group Header: @int WHILEPRINTINGRECORDS; STRINGVAR WorkingDay:=""; STRINGVAR finaloutput; In GroupFooter-1a @DisplayWorkingDays WHILEPRINTINGRECORDS; STRINGVAR WorkingDay; WorkingDay; In Details: @WorkingDay...

Hi I have 6 column data, of which I need to validate 3 columns to check if they are same in the subsequent rows having same ID, if Yes then the output should show it as one row only, if not display it as how it is. Data- ID...Name...Row...Exp...time...rowcount...

Hi, Can someone help me here. I need to create a query that will convert my 2 or 3 line record output to one line when the ID is same. ID...RecordCount..Name........Row.....Exception 1......1..........ABC..........10.......5 2......1..........DEF..........5........6...

Hi Can someone help me here, I am not a DB guy, I am BA and need some assistance for data mining. I have a function- fn_nonworkingdays (input- start date, calendar_id) returns int (0-working day, 1-nonworking day). Now I need to create another function that actually checks if 1. it takes...

Hi Can someone help me here. I need to create a cursor, and this I am not sure of. I have never created one. As a BA never created a cursor. Please help. DB Fields- Table- Accounts Acct_ID Acct_Name FiscalEnd_Date 101 US Bonds 10/31/2013 102 Small Cap 6/30/2014 103 Large Cap...

Hi Can someone help me here. I need to create a kind of looping formula, and this I am not sure of. I have never created one. Please help. DB Fields- Table- Accounts Acct_ID Acct_Name FiscalEnd_Date 101 US Bonds 10/31/2013 102 Small Cap 6/30/2014 103 Large Cap 3/31/2014 I have a...

Hi, Can someone help me here. Table- dbo.Account Field Name- FiscalEndDate Datatype- Varchar (20) sample value- FiscalEndDate 8/30 6/5 10/20 Logic- check the 'mm' and 'dd' in the text field "FiscalEndDate" with current system date and a) if month of system day and month are less than the day...

Hi, I have 2 parameters- Start and end date, which I used in the record selection to filter the record selection. I have a date field which displays all nonworking days (NonworkingDay_Date). Requirement: I need to display the Holidays only and not display weekends and display the dates as...

Hi I have a running total for a field {price} placed in Detail section. I have group my report based on customer ID. I have set the RT to sum every record and reset on change of group. Requirement- I have to keep the RT suppressed for every row entry and display only the last row entry for...

Hi Can someone help me here, I need to fetch/filter data in record selection to return data until previous month end. Current Date- 9/2/2014 Data Fetch- Until 8/31/2014 Please correct me if this is incorrect- Sample_date}<=DateSerial(Year(currentdate), Month(currentdate), 1)-1; Thanks

Hi, I have the following report structure. Detail Section: Field Names with Data are- Name ID Holidays A 1 1/1/2014 A 1 1/2/2014 A 1 1/7/2014 B 2 1/2/2014 C 3 1/2/2014 C 3 1/5/2014 In Detail-B section I have an @Array @Array - Formula...

Hi, I have data that is having 20 rows of data. Now I need to display total of the Top5 rows and the summary of the Top10 rows. What I mean is- I have 3 columns, ID, Amount, and Name. 1 10 A 2 5 B 3 6 C 4 9 D 5 20 E 6 15 F 7 13 G 8 12 H 9 17 I 10 22 J 11 33 K 12 27 L 13 31 M 14 2 N 15 7 O...

Hi, Could someone help me here. I have employee ID and employee name fields in details section. The requirement is after every 20 rows both the emp id and emp name must be displayed right next as a new column continuing the emp id and name. eg: Currently EmpID...