Getting Started

subtotal on one item only
On a report, I list a Stock name, Symbol, Security Type, Option Description, and Number of Shares. Would it be possible to subtotal only the "Stock" Security Type, and only show the subtotal for that Security Type, then go on to list the other records without subtotals? Example - Here would be sample data: ... 16 Jul 2008 23:21

Little Stevie is at it again
You just never learn. These newsgroups are provided by by Microsoft for FREE peer to peer support, not for snake oil salesmen like you. John... Visio MVP "Steve" <nonsense(a)nomsense.com> wrote in message news:Te-dnYr5198d1OPVnZ2dnUVZ_rjinZ2d(a)earthlink.com... I provide help for Access, Excel and Word applicat... 16 Jul 2008 17:11

Excel 2003 Sheet
I was given a Excel spreadsheet with Employee names. I have a large database with a Personal Table with Employee names and a whole list of other tables that I'm used to running queries. I'm still new to queries. I can run queries using the Pers_Table with employees and other tables. How can I import the Exce... 18 Jul 2008 14:26

concatenate
Hi fourm, I need to put a space in a concatenate field. SD: [School] & [Dates] Katella7/16/08 it should be Katella 7/16/08 Thank you. ... 16 Jul 2008 16:09

table design
I have customers, sales, inventory & brands tables. What is the best way to go about hooking a sizes table to this? The sales table is a junction table with one product from inventory being sold many times. ... 16 Jul 2008 18:13

Contact management
I need to create a customer database for a shuttle service. It is suppose to be very simple, each contact is seperate without any sub groups. And then there need to be a search function.. This is suppose to be used when a client phones for a booking, the operator then only enter the last name and if he was a c... 19 Jul 2008 15:02

Sharing the Database with Multiple Users at One Time
Is it possible to share one database with multiple users at one time? I sort of thought this was part of the point of a database...I created several on my company's shared network, but when I am in the databases, others can't access them. What am I missing here? Thanks. ... 16 Jul 2008 14:03

Linking to a specific cell and/or sheet in an Excel file
I have Access 2000. I have created a column for my hyperlinks in my database. I have even created the link. However, it will not let me narrow down the destination/address to a specific sheet in my Excel file. When I try to tweak the address when editing the hyperlink, it doesn't seem to work. In the address, ... 16 Jul 2008 13:01

Creating a hyperlink to a specific cell in an Excel file?
-- jana ... 16 Jul 2008 13:01

Help to query only last updated date
Hello, I need help on getting a list of Case ID with the very last updated date. Case Table (Case ID, Section ID, Section Update Date) Sample Case Table, Section ID, Section Update Date 1, A, 01/01/08 1, B, 01/15/08 1, C, 01/29/08 2, A, 02/26/08 2, C, 04/08/08 Each Case ID has multiple Section IDs. Whe... 16 Jul 2008 17:11