General

SQL/Query to retrieve top two records from a panel of data?
Hi, I have a panel of data organised as follows: id1, 1990, 100 id1, 1991, 101 id1, 1992, 100 id1, 1993, 103 id2, 1990, 80 id2, 1991, 90 id2, 1992, 81 id2, 1993, 83 id3..... etc. Is there any way to -- without re-structuring the data -- write a query that will return the top two records based on the t... 11 Jul 2008 21:16

Calculations using drop down menus
Is it possible to use values (i.e. numbers) to calculate totals? I have created a a field with a drop down menu of 3 numbers. I then try and multiply the value selected in the drop down menu with a number that i physically input into another field, and all that happens is the physical input is multiplied by eit... 9 Jul 2008 07:32

Sort on a form?
Hi all, Hopefully an easy one for somebody... I've created an input form for users to type in data about customer sales etc. They also use it when the customer calls to ask a question. At the moment the database (and therefore the form) shows the data as being sorted on the autogenerated ID number which i... 9 Jul 2008 11:38

Problems with Access 2007 runtime and Office 2003
"Louverril" <Louverril(a)discussions.microsoft.com> 在郵件張貼內容主旨 F324FA73-93EF-48B8-8735-26185B749482(a)microsoft.com 中撰寫... I do require the runtime files - the install package installs them. Where is your runtime installed - which folder? Thanks Lou "Matt" wrote: I am having no problems doing ... 9 Jul 2008 06:31

Message body
Hi, I'm using the below code to send an e-mail with attachment through MS Access,the code is working perfectly.The only problem is that i want to write more words in the message body in more than one line,but the code writes the whole text in one line only even after trying to use Chr$(10) to go to a new l... 9 Jul 2008 09:35

TIFF files - part two
Hi I recently posted about problems displaying TIFF files on one or two computers using an Access application. I was advised to source and install the Office XP version of the Office converter pack, which I did and successfully used on a PC which was exhibiting the symptoms despite running Office 97. Great -... 10 Jul 2008 13:25

Rounding Function
Dear all, I need rounding function. I already have a function for this purpose, but the result is not consistent when the user change the Regional & Language Options in Control Panel. Please help. Thanks. Chlaris ... 9 Jul 2008 22:58

Report Footer
Hi all, Am having some data which has to be displayed on the last page of the report at a fixd position. I use the report footer for this but the problem is that wherever the report ends, the data is displayed just after that..even if it is the startting of the page...( that's what the job of a report footer a... 10 Jul 2008 22:41

Ledger Account
I have following tables. I have not included all the fields and all the tables but the fields that I thought that are important for understanding the database structure. 1) Orders: Order ID (P.K) Customer ID (F.K) Employee ID (FK) Order Date Ship Address Ship Date, PO number, Ship Name, Ship Address, Ship S... 9 Jul 2008 02:26

Automatically Combining multiple spreadsheets
I have a spreadsheet for each department. On each sheet the manager has entered acivities by month in a list. e.g. 6 months start hiring 5 months Post openings. Each department has the same headers, but makes their own list in groups of months. I want to combine all the departmen... 9 Jul 2008 19:54