Tables
in [Access]
|
Day, week, and month totals I need to create a Database that will allow me to create a report of the data by day, week, and month on one sheet. Each day has only one record, but there are multiple fields in each record. Along the top of the report would have to be a list of dates, with the field totaled for that week in a column along the... 29 May 2008 18:58
relating rows to columns I was wondering if anybody has done this or wanted to do this. I want to relate row headings in table a to Column headings in table b. or put another way I have a primary key in one table i want to use for column headings in another table. I can create the tables in Excel and then import them as tables to Acces... 6 Jun 2008 14:52
Insert a Table in a Rich Text Box? Trying to insert a Table (using HTML code) through a module into a Rich Text Box based on some records... Any thoughts on how to do this... I need to create this as an HTML to send to an email... Thanks ... 30 May 2008 10:19
Cutting out around scanned drawing In Microsoft Publisher 2003, how can I cut out around a scanned drawing? I don't want the white "rectangle" area behind it for use in my poster. Thank you. ... 28 May 2008 09:17
Annual Calendar Okay, I have an annual calendar set up to track employee attendance which Duane Hookom (thankfully) pointed me to on the Hook'd on Access page. Now there are two issues that I would like some help with. 1. is there anyway to format this one page annual calendar to ensure that all 12 months remain on one page? ... 28 May 2008 15:02
referencing a form field in an adp query Is it possible to specify as a condition in an ADP view a value for a field in an access form? I.e., for an MDB one can specify in a query ".... WHERE forms!frm1!fld1! = 'xyz'....". What is the syntax for doing the equivalent in a MS/SQL view in an ADP? Thank you, Stuart ... 27 May 2008 15:09
Splitting an Access 2003 Database Hi !! Under what conditions should I split my database? How is it done ? What are the advantages of splitting my database ? Thanks in advance !! :) Vijay ... 28 May 2008 08:36
Change background of a form? Using the wizard to start me off on a form, I accidently picked the wrong "style". I just want standard - plain vanilla. Can I change it or export the layout & fields to another form that matches the other data entry forms in my database? -- Thanks for your time! ... 26 May 2008 22:28
multiple tables with same fields Hello all. I searched and found the following but do not think it meets what I am attempting to do. http://groups.google.com/group/microsoft.public.access.tablesdbdesign/browse_thread/thread/e2a70336e9a81462 There are five tables within my database: [1] inventory [2] to users [3] from users [4] shipped to leasing... 26 May 2008 20:07
notation Hi, I designed a table with a "phone"-field.. I want it to look like 03/775.99.82 In notation I wrote: 00/000.00.00 When I go to the next field access changes this to: 00\/0.000.000 What am I doing wrong? Should I make the field text or numeric Should I use # instead of 0 I'm completely confused... any he... 26 May 2008 03:27 |