Search results for query: *

Here are the fields that I have, DateTime CompanyNumber EmployeeID EmployeeName I am grouping by the companynumber. I wasn't able to get the codes that you offerred working, can you elaborate? Thanks

Hello I have a report that is grouping the a bunch of dates by companies. I would like to show only the latest date only. Does any know how to do this. Example: 123 03/02/04 1:02:00pm 454 John 03/03/04 2:03:00pm 454 John 234 03/24/06 1:02:00pm 232 Abby 03/24/06 1:03:00pm 232 Abby I...

Do you know how I can do this in the Access Criteria?

I have a query to filter a from a few tables like the below Datetime Company Id Person 04/04/06 1:00:00PM 123 34 Emily 04/05/06 9:00:00PM 123 34 Emily 04/05/06 2:00:00PM 123 34 Emily 04/05/06 3:00:00PM 322 34 Emily 04/05/06 3:20:00PM...

Thanks all, I got it to work now. I didn't know that about the Date and Now. Thanks Raskew.

Hello.. I'm trying to get a query to work but it's not working so well. I have this for my date criteria. =Now() or >Now()-14 I'm trying to pull data that are 1 to 13days old but if it is 14 days old, then I want to exclude it. My example is still pulling for dates that are beyond the 14...

Thanks PHV.. but I'm lost in all of this.. I'll have to rethink my way to get this to work. Thanks again for your input.

I have one amount field which I would like to filter out based on the code from another field within the same table. Example: TableA Job ID Amount 2 12 100.23 2 12 222.22 1 12 34.00 3 11 34.09 3 11 333.33 2 11 332.34 4 31 343.01...

Hey synapsevampire, Thanks much. The codes works great but I found out that what I wanted to do was totally different from my original thought process. Thanks much.

Hmmm. doesn't seem to work.

Is there a way to filter out a complete line of records based on one field? Example Jobcode Id Name Amount1 Amount2 1 12 JH 123.09 333.22 1 12 JH 333.34 543.02 11 HK 222.22 1211.03 3 11 HK 233.33 333.33 5 32 AX...

Hey lbass, That worked awsome! Thanks for helping me fix this problem. Hope you have a great day. Thanks again, you're always a big help!

this is exactly what I have: ........ If {tempreport1.jobcodereg}+{tempreport1.jobcodeot}=0.00 then " " else If {tempreport1.jobcodereg}=0.00 then {tempreport1.jobcodeot} else IF {tempreport1.jobcodeot}=0.00 then {tempreport1.jobcodereg}; ............

I had something similar to lbass. But I'm getting the same error. "A number, currency amount, date time, ofr data-time is required here." Both of the fields are number fields (0.00). Any ideas? I'm using Crystal Reports 8.5.

Hi all, I need help with this, hope someone can help. Thanks ahead of time. I have two fields. CollumnA and CollumnB I want to compare the values. If they are the same then I only want to output what is in field A. (If both are zeros then output blank". If they are different, but if either...

Awwww *hit... Damn it!! PHV, thanks dude... That was it!!! Baby Jesus... I've been pulling hair on this on for 4 hrs now.. Thanks dude..

Hello all I'm getting an error when I try to run this sql statement. The field "jobcode" is a text field. On the other hand, when I run the statement on a number field, the statement works fine. Any ideas, please let me know. ..... SELECT EPayHist.id, EPayHistDetail.jobCode AS jobcodereg INTO...

Okay, I'll go post this in another forum.

I see the error now: "You tried to execute a query that doesn't include the specified expression 'jobcode' as part of an aggregate function." Any help.. thanks..much..

I'm running this through an AD-HOC command. It just says "Cannot process Query". I have the created the below: SELECT co, id, lastName, firstName, 0.0 AS currGross, 0.0 AS curr401kee, 0.0 AS curr401ker, 0.0 AS curr401kloan, 0.0 AS...