Recent content by Rangie

Thanks, I have had to look at chaning the date format as I have no control over the data export format. This is what I typed: UPDATE [Maximizer notes] Set Date field12 = (mid(text field9,9,2) + "/" + mid(text field9,6,2) + "/" + right(text field9,4) I get a Syntax error in...

I have imported data into Access and wish to change the format of a field containing a date in YYYY/MM/DD format to DD/MM/YYYY format. If I set the field to a date type the import fails. Is there a way of using an SQL query that would fix the problem.

Checked the link. The functions in ths report are fairly simple. I did a test on the database and as it turns out that is where the problem is. Their are Users with no User accounts. I created a copy of the database with 1 User and evrything works fine. Thanks anyway.

5 Temp files and virtual drive space is 766mb. Increasing it to 2048 made no difference. Thanks Richard

I have created a crystal report with 2 sub-reports. The database is Act!. When compiling I get "Not enough memory for operation" message. The report will continue to compile, however the compliation does not work, even when it is run on the same mchine. I have looked at all of the...

The YTD formula's currently work on a Jan-Dec Year. How can I change this to default to Jul-Jun.

I have created the groups and summaries, however in trying the following formula and then creating a summary, I get the same result as a summary count without the formula, any suggestions? if {1st mtg} = weekToDateSun then {1st mtg} else date(00,00,00)

This company setsup meetings with prospects. Each prospect will go through a process of 4 meetings I need to count the number of meetings that each Manager is having with the prospects on a WTD, MTD & YTD basis. The date of the meeting is being recorded. A count for the number of "Meeting...