Search results for query: *

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

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

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

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

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

Can anyone suggets a Formula to return the last 12 full months. So I need to exclude all data from the current month. Cheers

Can anyone advise me on the best report scheduling softweare available on a very limited budget? All I need is to be able to export or e-mail updated reports daily. Thanks

Can I use the select expert to determine the results shown using a value in a subreport or a shared variable?

I need to return the date of the last day of the current month, in the correct format. Help.

Is there a way of counting the number of weekdays between the current date and the first day of the next month?

I have 2 tables joined using the left outer join. Instead of returning blank fields from the right table where there is no match on the join is it possible to return a default value?

Can you set a default value for the returned fields when using the left outer join? As it stands it will return a blank field, but I need a default value without having to change the table.