Recent content by Gazzamuffin

I get the following access violation message from Dr Watson (Win NT) when I try running a reprot. Exception access violation (0xc0000005), Address: 0x02e5bcec It seems specific to the two tables I am trying to link by the field MONTH. It closes down Crystal entirely when I try running the...

That worked a treat, thanks very much.

Sorry I didn't really explain this very well. I need to be able to group the date values by month and year to display the totals in a chart. I have a formula to show the month Month({date])and group by that but my data spans a number of years. The result is that all Jan data gets displayed...

How do I convert a full date to show just the month and year? i.e. 02/03, 03/03 etc Cheers G

I have a parameter query that is determined by the date entered on a form. The field contains either a date or is blank. If the form is left blank I need all data to be returned, if a date is entere I need only those greater than the date entered to be returned. I have tried...

That simple huh? Thanks for that. G

I have two tables with the same data fields. I have joined them by the primary key and now want to use the join to exclude all records that appear in both tables. The 3 options to join the tables only deal with records where the join properties are the same but I want to return all data from...

I am outputting the results of a query to Excel using the OutputTo function. At the moment it defaults to Excel version 5 format and I have no idea how to change the default format to version 7. Can anyone help? Cheers G

I figured it out. You have to use the GridRowColumnValue function to determine the column and row headings.

Thanks for that, but it's now showing all rows with null iformation as 0 but still supressing the columns.

If all the cells in a column contain null values the column does not diplas. How do I make it display all the cells with "0" instead? Cheers Gary

It just sets all background colours to no colour. I have written the same formula to determine the content of the cells and that works fine, but for some reason will not change the background colour.

I am trying to use an If statement to change the background colour of cells in a crosstab query based on the values of the column and row headings. I have written something like this but it just isn't working. if {column a} = "1" then if {row 1} = "a" then crRed else if...

Thanks changing it to "yyyy" worked.

It is not recognising the "y",-1 part of the dateadd function as the currenty year -1. Instead it is just returning the minimum monthtodate-1 twice.