Search results

if isnull({AccountReps.DealerNumber})= true then {AccountInfo.TrustDealerNumber} else {AccountReps.DealerNumber} This is what i currently have. I also want to add that if both {AccountReps.DealerNumber} and {AccountInfo.TrustDealerNumber} are null then use {AccountInfo.AccountNumber} any...

anyone have a solution? Thanks,

can anyone confirm that? Is there any other resolution other than switching to transferspreadsheet.

basically i'm having an issue where I can only get 256 characters to export into excel with the code below. I'm under the impression that ADO will fix this. How can I switch it? Dim dbs As DAO.Database Dim reportarray As Variant Dim rstGetExportData As Recordset Dim rs As...

I know how to do this from my computer but it would obviously have to be on the whole time and not locked or anything right? I'm trying to figure out a way to have a report emailed to our support email group daily. If I put the database on a shared drive it wouldn't work either right. I'm...

Alright I got it. I guess I was expecting a simple formula to put in the control source. I wrote some code on Report Activate to fill in a textbox instead from the link supplied. Seems to work today.. Private Sub Report_Activate() Dim date1 as String, date2 As String date1 = Date -...

Thanks but I'm still confused.

I've tried a bunch of different things on here, but nothing is working for me. Right now I'm using DatePart("WW", Date(),0) to get the week number. How can I get the date range to show on my report. This is week 29. So it should show today (which is a sunday) 7/13/2008 - 7/19/2008 thanks, QR

Nevermind.. I just created 3 commands for first, middle and lastname. Then left outer joined the commands to the main table.

I have 2 tables and one table only contains 3 fields: AccountNumber, FieldID and then Fieldvalue. I put this table in a subreport. I want to grab first, lastname and Middlename from this subreport. fieldid 4=firstname, 5=lastname and 6=middlename and place it on the main report. so on the main...

Thanks bob. im also looking into the add command custom sql method right now but again im lost. If the field is called Memo and its text how do i write a select statement for a new field called DealerNumber and have it be Mid(18,3) and a number. Doesn't look like there is a MID function either.

Thanks guys, is this option above doable in crystal. (im fairly new to crystal) if its possible to do it in crytal then this sounds the best and I wouldn't have to deal with subreports. Also I can't post my db since its financial. I also don't have permission to make any changes to the db...

I've tried a bunch of different ways and can't get this to work right at all. So on my main report right now I have a formula that displays a dealer number after formatting. my subreport would be the dealers table and I want to take the dealer name from that so all the dealer names show on...

Ok so I have a subreport that contains DealerNumber and DealerName now on my main report I have a formula that is if left({FundTransactionLines.Memo},7)="Control" then CDbl (Mid({FundTransactionLines.Memo},18,3)) and this is now the DealerNumber2. How can I add Dealer Name on the main...

I have a table and there is a field called memo and it starts with Control Number: 3478884803. the first 3 digits are the dealer number so I changed the format to be Mid 18,3. i also have a table called Dealers and it has dealerNumber and DealerName I want to add dealer names into my...

Thanks kempes it wasn't actually my selection formula afterall. it was the fact that I had inner joins and needed lefts :)

Right now I have this and it works fine: if isdate({?TradeDate})=true then datevalue({FundTransactionLines.TradeDate}) >= DateValue({?TradeDate}) and {FundTransactionLines.FundTransactionSource} = 10 and {FundTransactionTypes.TransactionTypeName} <> "Transfer Purchase" and...

this seems to be the issue. the first time the issue shows up and the amount of text is too long. how can I edit my query so the memo fields don't max out. what is the max amount of characters per cell? I assume I would just say: Left(Issue, 255) EDIT: it works perfect now!!! Using the above...

its definitely not the rows. and if i get rid of the memo fields it works perfect

I have tried both. nothing. Thanks for all your help so far though. the odd thing is this worked fine in 2007. we use 2003 at work. if i place 'On Error resume next' before that line it works fine but skips records and my numbers are off.