Search results for query: *

Thanks guys, I'm using Access 2000 -- the answer to my question ended up being StrConv([address],3) in an update query. It seems like in access2k you have to use a 1,2,or 3 instead of something like vbPropercase Thanks for the help

Hello, I have several thousand addresses in lowercase letters. What I would like to do is uppercase the first letter of each word (in other words, after every blank spot). I am somewhat familiar with building queries (not too savvy with VBA) so if anyone has ideas on easily accomplishing this...

Hello, I'm creating mailing labels in Crystal 8.0. I need to give the client the option of drilling which category they would like mailing labels printed for. However, when I drill down on a group, I don't know the way to suppress the group header so that it doesn't screw up the printing of...

No, the requestid is in the

Hello!<br>I am trying to write an SQL statement that looks at an individual 'request' and then checks the audit trail to see if the issue has been reopened.&nbsp;&nbsp;If the issue has been reopened, assign the issue a &quot;1&quot;, else assign it a &quot;0&quot;<br>the final table would look...

Hello,<br><br>I've created a crystal report (V.8) that runs off a stored procedure in a SQL Server 7.&nbsp;&nbsp;When I attempt to 'convert database driver' from ODBC to pdssql.dll (SQL Server), the report shows random errors.&nbsp;&nbsp;When I try to refresh the screen using the lightning bolt...

Thank you Malcolm,<br>Worked like a charm

Hello,<br>does anyone know a formula that can take an integer field for minutes and convert that into days, hours, and minutes<br>i.e.&nbsp;&nbsp;4000 minutes = 2d, 18h, 40m<br><br>Thanks,<br>Oren

Thanks Malcolm,<br>250 characters are enough, so how would I cast the field as a varchar(250)<br><br>Oren

Hi everybody,<br>I'm writing a report in Crystal that requires the ability to select records on a description box that Crystal interprets as a memo or blob field.&nbsp;&nbsp;Because of that, I haven't been able to use that description field in any formulas or in the select expert<br>Has anyone...

I'm having the EXACT same problem so an answer would definitely be appreciated