Search results for query: *

Fair enough - I agree but my resources/bosses/current situation and timescales mean that I can create a sales report with all forecast and actual data totalled up but in addition include a latest comment on a given account. I can use Excel to do this but you are right maybe I should just revert...

Any ideas if there are limits to cell lengths in Excel pivot tables linking from an Access 2000 data source. If there is a limit, are there any ways of getting around this to pull in a lengthy memo field. Im using Excel 97 SR-2

Please ignore last post - posted incorrectly

Any ideas if there are limits to cell lengths in Excel pivot tables linking from an Access 2000 data source. If there is a limit, are there any ways of getting around this to pull in a lengthy memo field. Im using Excel 97 SR-2

What is the best way to take information from a form and output it into an e-mail to be distributed? Ive thought of a Data Access page however Access 2000 is not allowing me to export a data access page into an e-mail's body. Any thoughts ?

Thanks thats finally worked !

Im getting the following error when I try to run this query : Syntax error (missing operator) in query expression ". SELECT c.MEMBER_HOME_COUNTRY, a.Member_ID, c.MEMBER_NAME, d.PRODUCT_MARKET_NAME, a.Projected_Annual_Amount FROM dbo_Member_Annual_Spend_Projections As a INNER JOIN...

You are right - I actually did not think I could put a join in for the purposes of the query as there was a link to another table which I thought would have confused it. Thanks a lot - the simplest of fixes are often the most rewarding

Hi, I am running a query which includes an EmployeeID field contained in table "Customers". I would like to do a lookup to another table (Staff)which is not linked to "Customers" which contains the fields StaffID and StaffName in order to drop the Staff_Name into this...

In response to your last post : The problem is that I would like to pick up some other fields in the query e.g. Customer Name (which sits on the Customers table), Category Name (which sits on the category table). This means I have to take fields from the three tables (as indicated in the full...

Sorry, The query looks like : SELECT a.CustomerID, b.CategoryID, c.Projected_Month, c.Projected_Amount, c.Date_Projection_Made FROM b INNER JOIN (a INNER JOIN c ON a.CustomerID = c.CustomerID) ON b.CategoryID = c.CategoryID Group By a.CustomerID, b.CategoryID, c.Projected_Month...

Hi, I have 3 tables : Customers (a) Product Categories (b) Monthly Projections (c) There can be more than one projection made for each category per month (for each customer). Firstly, I would like to take the most recent monthly projection per category per customer. This can be done via a...