Recent content by Megs628

Thanks! So simple! Clearly couldn't see wood for trees with a formula fixation

Hi - Using Excel 2016 Use a spreadsheet to complete a comparison with our receipting vs bank settlements. The bank provides simply a credit summary total for each site for the previous days transactions. This can be made up of multiple transactions within out receipting spreadsheet. What I...

Hi - Using Outlook 2016 We are importing a significant number of individual tasks via a csv import file. Is it possible within the import process to assign a "single" person to each task? Or is it possible to do a bulk assignment to a single person once the tasks have been imported? Right...

Thanks - good suggestion. I was using the search function as the text maybe anywhere in the search narrative. It cant be guaranteed that it will always be the first x number of characters.

Afternoon Using Excel 2016. I have a list of data - refer to attached s/sheet - I wish to search for nominated strings within text and if found return the nominated code for this text. I would move the NAME_SEARCH & CODES to a separate sheet and also input named ranges but for the purposes of...

Hi - Crystal Reports 2011 - ODBC connection to Pervasive DB I've written a production report to list all arrivals and all departure for a specific production date. The user selects the nominated Production Date and then runs the report. e.g. Record selector formula {QUOTE.ARRIVAL_DATE} =...

Thanks for all your help. Fixed it. Missed "optional parameter" value in parameter options. Changed and code works :-) Thanks!

Apologies should have included. I ran it for date range 7/9/2015 - 11/9/2015 It includes following Quotes within this date range: 50439 50581 50642 50741 50760 50783 50845 50936 50941 49512 50652 50657 50712 50737 50174 50342 50410 50459 50608 50796 50950 50593 50717 50755 50969 50539

Thanks [bigsmile], tried running report on Crystal 2011. Tried both suggested solutions and Crystal just isn't processing how anticipated. It either renders a report with no data or enforces data into all parameters. I understand the coding is saying to do one or the other but Crystal isn't...

Great thanks - that worked in removing the Number error. I changed it slightly as I need it the user to choose one or the other option. i.e. choose a single quote & add quote number or choose a date range. The date range shouldn't be included at all if the quote number is nominated. Record...

Yes, exactly. Report needs to offer option of printing a single quote or all quotes that are within the users specified date range. Unfortunately even if a single date range was selected multiple quotes will print. The user has to be able to nominate the actual quote number required.

Hi. Using Crystal Reports 10. ODBC connection to database. My existing report has a Record Selector - {Quote Arrival Date} in (?StartDate) to (?EndDate). This provides the user a start date & end date selector to create report. This report will include all Quotes within their selected period...