Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

I have a very large database on my file server which is used everyday. My problem is that on busy days, the database bloats up to about 950mbs. I need something to send me a warning to my email so when the database hit 900mbs, so that I can compact it back down to about 800mbs. The database does...

I want to install the NICE Digital Version 7 onto my desktop. But have no recorder. How can I integrate a different type of recorder such as digital video feeds from a VCR to the workstation? Any ideas, please let me know. thanks much..

Hello, I have a Sum field that displays the total of a collumn. Unfortunately, the total is not correct. It is off by a few cents. I sent the field for two decimal places but it is still incorrect. For example, if I manually added the collumn it's 45.67 cents but the report rounds off to...

Hello all, I have three tables, that I would like to join together. This is my statement for two tables, how do I modified it to work with three table? My third table is called EAccr it have multiple fields but I only want the id and begin date fields. The fields are EAccr.id and...

I have a number field: 2005060801 I need to reposition this into: 06082005 Any help thanks.

Hello all, I'm pulling from two table. Table A have only one record per each employee which are things such as Id, name, and age. Table B holds multiple records for these employees such as books read, reports written and types. When I pull records from Table B for my report, I get multiple...

I have a field called phonenumber. (209)234-2343 I need to trim this to just the area code. Any help thanks. 209 I'm using crystal 8.5

Hello, I'm try to set a Select Expert formula. I want to set it to pull data if the field EInfo.termDate is null or greater then 12/31/2004. I don't know how to write the formula. Any help please let me know. I'm using crystal 8.5.

Hello, I have a date field inside a table. This is the only field inside this table. Does any know how to automatically generate dates into the field? For example, I need the table to list all dates from 2004-2010 in format of 01/01/2004 and etc. The end result would be: datefield...

Hello, I'm posting this again because I think I posted it in the wrong forum earlier. This should have been a SQL question. I need some help with this. I have over 1,000 access 97 databases. I need to to pull only data from three field in one table from each database. How can I do this...

Good morning, I need some help with this. I have over 1,000 access 97 databases. I need to to pull only data from three field in one table from each database. How can I do this without writing a sql statement for each db? What I have now: SELECT CProcessDates.co, CProcessDates.processDate...

I have a phone number field (000)234-0000. If there is no phone number then the output is ( ) - Does anyone know how to write a formula to replace the "( ) - " with just a blank spot? Thanks much. My current formula is: whileprintingrecords; if not isnull ({EInfo.homePhone}) then...