Search results for query: *

I have numerous running totals on a report does anyone know if it is possible to printout all of the formulas for each running total, rather than having to click on each one to see what the formula is? Janet (MI Manager)

sorry, I have a spreadsheet that has come from a parnter organisation and contains company names and addresses, some of which are on our database some are not, the problem is thie unique identifer for the company does not match ours. So far I have input their unique identifier for the company...

Hope someone can help, I have a spreadsheet that I have imported into access, I have linked this to our 'live' database via odbc, and want to join the 2 tables using a query, however the field I need in the linked table is not available in the list of fields. can someone explain why and also...

I have setup a parameter field with multiple options and I want the user to be able to either select one, select more than one OR select ALL. I have placed the field on the report header, however it only prints the one of the options selected I have read that I may need to use an Array, however...

I want to create a repot that counts the number of times and order is allocated to a particular budget(s) The problem I have is that any one order can have more than one budget code. We have field1 as the main budget code and field 2. as additional budget code(s), the system will not allow you...

Running total does not give the correct answer can you help I have created 2 running totals that do the following field1. distinct count = formula field1 = action plan field2. distinct count = formula field2 = action plan example Order Number 12345 field1. = Action Plan Field2. =...

Hi The task i have to to produce a report showing 12 months, and a year to date running total. That only counts the number of customers who have placed an order in the 1st month of year. The next month should only then count customers (that were not counted last time) that have placed an...

Is it possible to produce a report that will show me all the customers who HAVE NOT placed an order, OR have not placed an order in the past 2 years. I have a companies table, with a left join to Orders table. It shows me all the companies and prints the date of the order(s) or leaves it blank...

Can you Help I have a field that is used to hold a code relating to the status of a project for a particular company. In the table there is also a date field that is used to hold the date the company achieved a certain status. I want to print out for a company all the status codes and the...