Search results for query: *

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 ?

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

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

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