Search results for query: *

I am printing our forms letters from an access database. Three of the fields are yes/no, but print out on my for as 0 or 1. How can I have these fields print out on my letters as yes no instead of 1 and 0? tia Pat

Thanks for everyones input and discussions on this. Actually, it original query was this: SELECT * FROM dbo.dhel_view_sample_test_results WHERE (date_received >= @date) AND (date_received < dateadd(day, 1, @date) AND (lab_section = 'PS')

This works: SELECT * FROM dbo.dhel_view_sample_test_results WHERE (date_received >= '2006-04-13 00:00:00') AND (date_received < '2006-04-14 00:00:00') AND (lab_section = 'PS') This Does not: SELECT * FROM dbo.dhel_view_sample_test_results WHERE (date_received >=...

That worked Paul... Thanks so much!

I have a column in my report called TG_Count. I have tried placing the following as a page footer or report footer, but neither works. =Sum([TG_Count]) I receive an #Error on my page where the sum should go. The report is produced from a query. Help please... TIA

There was a farmer who had a dog... and BINGO was his name-O! B-I-N-G-O That worked! Thank you so very much!

Well, I had a copy of the db here at work so I tried it. What that produced was one row if there was data in email1 AND email2. What I am after is actuall 2 rows, one containing email1 and the other containing email2.

GENIUS! Thanks, I'll give that a try when I get home from work.

I am working with a database which contains among other fields a name, email address 1 and email address 2. Some rows do not have anything in the email address 1 or 2 field, some have info in the 1 field and some have info in the 1 and 2 field. I need a query that will produce a seperate row in...

That worked splendidly Katy44. Thanks and a tip of the hat to you! Pat

I am using VB6, CR8.5 with OCX and an access 2000 mdb database. To create one of my reports, I need to do a selection on a date field. As it turns out, there may not always be a date in the database. My sql is a follows: sSQL = "SELECT Date_Closed " _ & "FROM Claim " _...

BINGO!!! Thanks Dave! Pat

I am using VB6, CR8.5 and OCX - as everyone probably knows by now! ;o) I have created a combobox on a form which loads up with dates in the form of 06/01/2001, etc. On my report, I have created a parameter field called PDate which is the type Date and also have a database field called...

Thanks Dave! month({Table.DateField}) = {?MonthParam}will work perfectly. It's sure easy when you know what the heck you are doing! ;o) Thanks again, Pat PS - You're saving my butt ya know!

I am using VB6 with an mdb database and using the ocx with CR8.5. I have a date field setup as 03/01/1999. Can I setup a selection criteria along the line of "where date_field like '03'" and select all date fields that start with 03? I keep getting an error through crystal stating "string...

I'm using VB6 and an access database. This is an existing application which uses the OCX. There are numerous reports already setup with the OCX and I was a little nervous about switching everything over since the bulk of the application is working.

I using access 2000 database and the ocx not the rdc synapsevampire

Unfortunately, the link http://www.crystalcommunity.com/formulas.php is no longer a valid link.

I am using VB6 CR 8.5 and OCX. I have a database date/time field on a report in the format of mm/dd/yyyy. I am needing to pass a parameter from a form to search by yyyy. Would the conversion from mm/dd/yyyy to yyyy be done on the crystal side or the vb side and how might you do this? TIA

Well... no... I was but now it seems to be working fine. :o) Hooray! Thanks anyway Dave and hope all is well with you. Pat