Search results

I have managed to obtain totals in the report that refer to the same field name, so I am unsure why I can't produce percentages to show the same. The formula for the 23,162,864 number is 'Total of Total Units' and the formula for the 43,676,991 is '=Sum([Total Of Total Units]), and to get the...

I can't address the duplicate field names, as the calculations need to refer to the same field name. For the total 23,162,864 I am totalling the 'Total Units' for colums WWC Age 1 to WWC Age 5 and for the Grand Total 43,676,991 I am summing the 'Total Units' for rows (1) Months Since LREC: =>0...

I'm not getting the results I expected. As per my examples, for the top left hand box I am returning a result of 500% when infact I should return a 53.03% result and for the left hand bottom cell I am returning 19.3% when infact I should return a 5.16% result.

This didn't work. Just to be clear that the current fomulas/results shown are incorrect, therefore I am after new formulas to provide the correct results. For the left hand side cells, I am looking for the percentage partipation of units for each of the rows - for example: Total Units for (1)...

For the left hand side: =Sum([Total Of Total Units]/[Total Of Total Units]) For the bottom: =Sum([WWC - AGE 1/[Total of Total Units])

For the left hand side cells, I am looking for the percentage partipation of units for each of the rows - for example: (1) Months Sine LREC: =>0 and <=3 (23,162,864) vs Grand Total of Total Units (43,676,991) - this should return 53.03% For the bottom cells, I am looking for the percentage...

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

To be honest, I didn't know that you could apply conditional formats. Any tips on how to achieve this would be welcomed.

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

SOS, Apologies, you didn't previously mention that you had imported the sample tables. The version of access that I am using is in the attached screen capture.

SOS / Wilpeter, I have now joined Product Code and Brand, and as you can see from the attachments I now get a total of 12,537 results (when I should expect 9,999). I posted both tables in a previous entry on this thread, can someone else import these into a database and tell me if you get the...

wilpeter, I have followed your advice and tried the following: 1. I removed Table1 Brand and Replace with Table2 Brand with the "Group" criteria and I still get 37,611 records (see image 3/4) 2. I then included Table2 Brand alongside Table1 Brand (both with the "Group" criteria and I get...

I'm actually using Access 2007, so I'm unsure if this makes a difference. I have run the same query (see attached screen shots) and still get 37,611 results.

Okay, I have opened the SQL view and entered the DISTINCTROW field as requested and I still have 37,611 results returned. SELECT DISTINCTROW [Table1].[Product Code], [Table1].TotalUni, [Table2].TotalVal, [Table1].Brand FROM [Table1] INNER JOIN [Table2] ON [Table1].[Product Code] =...

vbaInet, Thanks again for your input. As you can guess I am not an advanced user of MS Access and as a consequence I do not have any SQL included within my query, is there any other way I can use this command without creating an additional SQL statement. Apologies if I have misunderstood your...

dkinley / vbaInet, Thanks for your responses, however after coming back in fresh this morning, I am still getting duplicate rows in my queries, even after I have replaced the Null fields. I've attached a sample copy of my two tables in an Excel format. Each table has 37,611 records and as soon...

dK, Thanks for the prompt response. I have tried to run the same query this time linking on Brand A and it returns the correct number of fields, so the Null field is my issue. Therefore my next question is how can I replace all of the Null Fields with the text "Group" ? Thanks again.

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