Search results for query: *

I don't know why I didn't even think of doing that but it did the trick, thanks a bunch!

I need to be able to pull data from a sql database for month to date and last full months data. I'm having an issue with date time. Here's an example of the sql where clause: Where (((dbo_RMS_Roll30DAY_SALES_EXCH_DLY.TXN_DT) Between (Select FetchStartDate From FetchDateTable) AND (Select...

That did it, thanks for your help!!!

I'm running a function that should pass dates to a table. In the following example the variables debug as MyDate1 = #12/1/2004# and MyDate2 = #12/31/2004#. When they load into the table they both load as 12/30/1899. Does anyone know what's going on here? Public Function FetchDate() ' Function...

Thanks PHV, Now() does work. I'm not sure why I didn't try that to start with.

I'm getting an error: "Function isn't available in expression in query expression 'dbo_RMS_Roll30DAY_SALES_EXCH_DLY.TXN_DT between date()-7 and date() and dbo_RMS_Roll30DAY_SALES_EXCH_DLY.DRCT_FLFLL_FLG = 'n'". If I remove the date() it returns data. Thanks!

Since it's from one Access database to another Access database the connection string does not work. Thanks for the reply!

I have a query that uses on database to update another. The one that is updated is password protected. The problem comes when the query runs on the first database it prompts for a password. Since the whole idea was to automate the updating of the second database this will not work as designed...

The pass thru query is in an Access 97 database.

I've written the following pass thru query to a SQL database. I need to pull data from 3 days ago. The SQL date field is a datetime field and the query is pulling way too many records. Is there a way to convert the date in the pass thru query? SELECT a.TXN_DT as date, a.ORD_NBR as ordno...

Additional information: We are using Crystal 8.5 sp3.

Here's the issue: I have two tables that are joined by the ord_nb field. The primary table has a field called sku. My customer wants to join an Excel spreadsheet that has a list of sku's to the tables. They want to see all of the sku's that are on the primary table but want the sku's that are...

I have an issue sending an email in Access. The code is running on a server as a schedueld task. It all works fine until the code try opens Outlook 2002. At that point a message box appears that asks for the outlook profile ("choose profile"). It defaults to the company profile and when I click...

I found the answer. Here it is: // Find the first date of the month based on the date field datetimevar firstDate:= datetime(year({DC_STOCK_OUT_LOW.cal_date}), month({DC_STOCK_OUT_LOW.cal_date}),1,0,0,0) ; // Find the first date of the next month based on the date field datetimevar...

Does anyone know how to get the last day of a month in Crystal 8.5? I have a date field and I need to get a percentage using the amount of days in a given month. Thanks!

Sorry please ignore this question. I meant to add a new thread.

Does anyone know how to get the last day of a month in Crystal 8.5? I have a date field and I need to get a percentage using the amount of days in a given month. Thanks!

Thanks Mike, The spaces are on the FoxPro side in the cursor. The alltrim function doesn't work because as you pointed out they are fixed in length. I did try the MyVariable = LEFT(MyCursorField,AT(CHR(0),MyCursorField)-1) solution and it did not solve the issue. We have decided to go back to...

Thank you Rick. The problem is that we create an updateable cursor (tcCursorName) from the structure of the specified local FoxPro alias (tcAlias). We do not pass any field names until we query Oracle (SELECT * FROM MyTable WHERE 0=1). We then populate the VFP cursor with data from another...

Thanks, I'm using SELECT * FROM MyTable WHERE 0=1 to create the structure. The problem is that the data that is copied into my cursors contain extra spaces. For instance we changed the field length in Oracle from 6 to 10 and the type from char to varchar(2). Now when I pull data from Oracle...