Search results

I have attached a sample of a report that I have created from a crosstab query. The problem I am having is with the % Part. (participation) calculations on the left and at the bottom of the page. Can anyone help me with the calulcations to return the correct participation percentages. Thanks...

I have created a cross tab query that details the age of stock (row) and weeks cover of stock (column) with the stock cost (sum) as the main data within the query. I have now created a report for this query, however I would now like to add a RAG (Red, Amber and Green) status to the report. The...

I want to set up a macro to run a query, open a report and send the report in a pdf format to an extrenal user. I have written the macro, however I have two issues: 1. When I run the macro, I get a messge from MS Outlook stating that an application is trying to send an e-mail on my behalf and...

I have a date field formatted as dd/mm/yyyy which denotes the date that the product was last received into the business. I want to use this field to complete some analysis on the age of the stock to give me the following results: 0 - 3 Months 3 - 6 Months 6 - 9 Months 9 - 12 Months 12 - 18...

I am joining two separate tables that I have downloaded from our host system into a query and linking them via a common denominator (Product Code). Every Product Code has three unique entries, one for Brand A, one for Brand B and one for Group (Brand A & B) however the Group entry is a Null...

I have a series of values within a table that includes a number of null values. I would like to include this field within a query, however if the value is null I would like to show a 0, if the field is not null, I would like it to show the original value. I have tried to use the IsNull in an...