Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Textbox Properties
Saxman - 3 Dec 2005 8:55 PM - 2 messages
I have a textbox on a form which has hyperlink as the data type.  The default format for a hyperlink is a file or web link.  Is it possible change the default to an email address for all records without the need to ...
Score I cannot believe you charge 4 the softward & then assistance too
Scott - 3 Dec 2005 8:40 PM - 2 messages
I cannot believe that Microsoft charges a small fortune for their software and then charges $35,oo per request 4 assistance in using the software! My system--trial for now--offers Outlook and when I went to pick up my ...
Score i anable to sent the mail my widow is me how to corret it
akcmohan - 3 Dec 2005 5:23 PM - 2 messages
how i will able to send the mail as it is not working it is ther is a error ...
Score Switchboard
Bruce - 3 Dec 2005 3:48 PM - 4 messages
SwitchboardID      ItemNumber      ItemText      Command      Argument       1      0      Main Switchboard      0 ...
Score ListBox Select
DS - 3 Dec 2005 2:23 AM - 9 messages
I'm trying to selected a record in a listbox based on a record from another form.  When I click on the command button I want to highlight the row in the listbox that matches the textbox. Any help Appreciated. Thanks ...
Score Address Book - New Page for New Letter of the Alphabet
GeeJay - 3 Dec 2005 12:31 AM - 7 messages
I am wanting to print out my Address Book and would like to force a new page for each change in the alphabet.  Is there a simple way of doing this, pleaser? ...
Score Programming Problem
James Featherstone - 2 Dec 2005 11:04 PM - 2 messages
In one of my tables I have a field that is a Yes/No field, I want to get Access to take records with a yes in that field and move it to another table. Or, if that is not possible then atleast not have that record show up on a ...
Score After Update Event
Dj - 2 Dec 2005 10:26 PM - 2 messages
I thought I entered the following correct, but it doesn't seem to be working. Can someone tell me if what I'm trying to do is possible. I have a very simble two field table.  Say one field is words.  When I print ...
Score openForm button
vassilis - 2 Dec 2005 8:57 PM - 2 messages
hi everybody there is one Tabular Form that shows all my records and another form based on the same tables but shows only one record at the time.i used the button wizard to add an open form button to the first (tabular form ) so there is a ...
Score Sorting so Blank Contacts are at bottom
Stilla - 2 Dec 2005 8:54 PM - 5 messages
Hello, I just imported my contact email list from an excel file.  In Outlook, the list appeared at the bottom of the contacts "space" so that there are a zillion blank lines before my "A"s even start... I can't seem to "delete" the ...
Score Calendar and time sheet
Fehn - 2 Dec 2005 8:41 PM - 56 messages
Does anyone know how to make this possible ad updatable in MS Access? Description - 12/1 - 12/2 - 12/3...... 12/31 Sample1    -   2    -        -    5  .....etc ...
Score Subform Vs main Form
Patsee - 2 Dec 2005 6:18 PM - 2 messages
I have a simple music dB that contains cd and DVD titles, artist, recording company and date, all on the main form called Recording, and the equivalent table. A sub form and table called Tracks contains the track titles. I have created a third form for searching the db for title. It is ...
Score how can i set up my home page
matthew - 2 Dec 2005 6:00 PM - 2 messages
how ca i set up my own home page ...
Score Display records in date order, form view
ReadReadWrite - 2 Dec 2005 5:34 PM - 3 messages
I'm very new to Access--self taught using Access Inside Out, Access for Dummies, and trial and error.  Just created a simple database (form and table) for interlibrary loans.  My supervisor would like to see the most recent record when she opens the ...
Score Question on Input Masks
Norm75 - 2 Dec 2005 4:35 PM - 2 messages
A newbie here - I am putting several input masks into a date/time field in a table. The mask is the usual: 99\->L<\-00;0;- and I have a couple as: 00\->L<\-00;0;- . I know from reading that 9 signals not a response necessary ...
Score Selective Address Labels?
Saxman - 2 Dec 2005 2:11 PM - 4 messages
I have one more problem to solve before completing my database. I need to save address labels to file.  I know Label Wizard does this, but my problem needs to be selective.  The customers are 'active' or 'not ...
Score Search Forms... I know... I'm not the only one!
ollygregory - 2 Dec 2005 11:11 AM - 3 messages
Ok... There are lots of threads relating to this... but i cant seem to find one that points me accurately enough in the right direction... hence my need for assistance! I need to create a search form that looks up data over about 8 or 9 fields in anoter table and then brings back all relevant records. I need the user to be able to enter data either into either one or all of these fields and then for all of the relevant records to be displayed in another form called 'Property' that the search form, 'Search Form' is based upon. ...
Score Data in a query
halima - 2 Dec 2005 10:23 AM - 2 messages
Goodmorning, In my query I have a bill date and I would like te make a filter to have a view on all bills>than 90days as well as all bills< 90 days. Maybe you will get this mail twice, put I am not familiar with the ...
Score DLookUP
DS - 2 Dec 2005 6:34 AM - 5 messages
I need to run a DlookUp to search for records and then when it finds them I want to exclude these records from a rowsource.  How would I do this? I've got this so far NZ(DLookUp("MenuCatID","MenuInfo",[MenuID]=Forms!MenuMaker!MenuID),0) ...
Score Parameter value
Savanah - 2 Dec 2005 5:32 AM - 3 messages
I have a dialog box with options and a list box that I can choose the name of the protocol, than I am running a line chart in a form, with a query on the row source SELECT [qry Projected Enrollment].[Max Of Week], Sum([qry Projected ...
Score Form record navigation behaviour
gavin - 1 Dec 2005 8:32 PM - 5 messages
The data entry form on a database I am using is showing something I haven't come across before. The record navigation at the bottom says "1 of 1" instead of "1 of 4157". I have a feeling that this is may be connected to ...
Score Data Type problem
Joe Cilinceon - 1 Dec 2005 7:38 PM - 5 messages
All of sudden I'm having problems in queries with Expressions that I set a criteria on. Calculated dates I can't use Date() below in the criteria. Iif statements that return a 1 or 0 and put say a 1 in the criteria I get the ...
Score How can I get table data into a text box
bayshore - 1 Dec 2005 5:46 PM - 2 messages
I would like to be able to pass variable data (product name) from a Textbox on a form to query data in a Table and then have that query return the (price) value into another textbox on the form.  I really wanted to automate ...
Score Merging of Two Databases
kjmom57 - 1 Dec 2005 5:27 PM - 5 messages
I have two database files; exact same fields, etc. just with different data that I need to merge together to form one database.  One is a small file on disk that was worked on at home and the other is the main file which is ...
Score Updating/editing two tables in forms
Help me please totals on page in report - 1 Dec 2005 5:06 PM - 2 messages
Please help:  I am trying to manage land and properties in a small town.  I have 2 tables: Owners and Property One owner may have one property or own several properties The form: frmOwnersAndProperty has both tables on it:   The Main form is ...
Score Auto fill of data
k.roberts@ucas.ac.uk - 1 Dec 2005 5:01 PM - 3 messages
I have 2 tables within a database.  I wish to compare field 'ID' in table 'Report' with field 'SchNo' in table Final List, and bring forward the data from field entitled 'Name' in table Report, into a field entitled 'SchName' in table Final List if the 2 id numbers match. ...
Score Help With Expression Please
Saxman - 1 Dec 2005 4:42 PM - 8 messages
=DCount("*","Clients","[Therapy1] = '1'")+DCount("*","Clients","[Therapy2] = '1'")+DCount("*","Clients","[Therapy3] = '1'")+DCount("*","Clients","[Therapy4] = '1'")+DCount("*","Clients","[Therapy5] = '1'")+DCount("*","Clients","[Therapy6] = '1'") The above works fine.  It sums up the number of therapists who specialise in a particular treatment.  I need to add which therapists are active ...
Score Duplicates
DS - 1 Dec 2005 2:57 AM - 4 messages
I have INSERT SQL code that I run.  I'm not quite sure how to do this. I need to search for duplicates either before or after the code is run.   All of the info is on an unbound field just waiting to be inserted. ...
Score Drop Down List Question
John Calder - 1 Dec 2005 2:10 AM - 4 messages
Hi I run Win2000 with Access 2000. I have created a table & form which has an entry of a "First Name" and an entry of a "Surname". I would like to have a combo box on another form that shows the entire name (First namd and Surname) ...
Score how do I create an if/then statement in a query in access?
christopher - 30 Nov 2005 9:49 PM - 3 messages
I have an output field in my db that lists  [SumOfBALANCE] however, when performing a later function it turns out that if this field is blank I get a blank result.  The fields won't sum a # field w/ a blank field. ...
Score mdbt file extension
Gerry b - 30 Nov 2005 9:47 PM - 3 messages
We share our database files.  For some reason, when we open our 2003 databases (recently converted from 97), we are getting a database file name with .mdbt as the extension.  This happens when the database is open. We see the .ldb file which indicates that the database is open. ...
Score Help with calculations with an unspecified # of records
LynneMc - 30 Nov 2005 9:21 PM - 3 messages
I am new to Access & trying to create a field that will calculate the "balance due", by taking the "TotalTripCost" and subtracting all the "PaymentAmount"s.  I can get it to subtract the first payment, but I can't ...
Score option group - is this possible?
PaulaCMT - 30 Nov 2005 9:18 PM - 5 messages
Hi there Thanks to all who helped with my last query - i am having difficulties again!!(surprise!) I would like to put an option group on my subform with 3 options. Only one of the three options can be selected. If the first option is selected then i ...
Score Mail merge: How do I print additional fields in address?
lynbo - 30 Nov 2005 9:16 PM - 5 messages
Wish to create and print letters and/or labels and/or envelopes in mail merge using contacts data.  However, cannot get complete info to print -- i.e., need full names w/honoraria, titles, company names, etc.  How do we set ...
Score increase size of form footer
Miguel Vivar - 30 Nov 2005 8:50 PM - 3 messages
I have a large set of questions in my form and I want all these questions to appear in my form, but because of the number of controls, only some of them appear in my form, the "form footer" does not let me show all the questions.  ...
Score Running A2000 and A2003 on Same PC
Nancy - 30 Nov 2005 7:27 PM - 3 messages
I have a need to have both A2000 and A2003 running on the same PC in order to support my customers.  Are there any compatibility issues with running both A2000 and A2003 on the same PC?  A2003 would be installed in a different ...
Score Creating a new database that will be updated annually
Jim P - 30 Nov 2005 5:58 PM - 5 messages
I'm trying to track payroll data that will be update annually.Should this be done with a data base for each year or should a copy the 14 tables planned for each year with a name that start with the year. Example 2006earnings, ...
Score Date _and_ time in same box?
StargateFanFromWork - 30 Nov 2005 5:54 PM - 4 messages
At the top of the entry form for the contacts example database, there is this line of code in a box: =IIf(IsNull([lastname]),"",[firstname] & " " & [lastname] & ", " & [Birthdate]) That got me to thinking how nice it would be to put in the FOOTER of a ...
Score What causes data to corrupt?
Lori - 30 Nov 2005 5:49 PM - 5 messages
What causes data to "corrupt"? ...
Score Access skill level question
kw_uh97 - 30 Nov 2005 5:38 PM - 11 messages
I have been reviewing the Northwind sample database application in Access 2003. I have completed my own application like the NW database presents. I feel that I understand how the examples were coded and created. Microsoft does not have an assessment or certification for VBA or I don't know of any. ...
Score how do i retrieve value from table to a text box on a form
bayshore - 30 Nov 2005 4:15 PM - 2 messages
I am an Access novice however, I am attempting to retrieve a value from a two field product table. (Product & Price)  I have variable prodcut data placed in a textbox by user button selections.  I had hoped to figure out how to use ...
Score Expressions
k.roberts@ucas.ac.uk - 30 Nov 2005 3:50 PM - 5 messages
I am using =DatePart("yyyy", [OrderDate]) to pull through the month displayed as mmmm format, from a field containing a date in ddd d-mmm-yy format.  I am getting an error back - #Error.  Can anyone tell me why? ...
Score Syntax to refresh subform
Jack Sheet - 30 Nov 2005 3:33 PM - 8 messages
What is the syntax, please, to insert into the Private Sub Form_Current() event of a parent form in order to refresh a subform contained within that parent form? I have a subform called "F_TJA_Tasks_Sub" and I have tried the following ...
Score Expression Builder
CSkoog - 30 Nov 2005 2:40 PM - 2 messages
I have a querie with many different states.  I need to have it exclude two of the states in the querie IE: AZ and MI. ...
Score Error 3044-Access 2003 Database Error
brendanheckman - 30 Nov 2005 2:39 PM - 2 messages
Getting error 3044.  Incorrect path to network drive.  How can i change the path that access is trying to pull?  Sorry but I'm new at this and cant figure this out. Thanks brendanheck***@yahoo.com ...
Score Number format
k.roberts@ucas.ac.uk - 30 Nov 2005 1:00 PM - 6 messages
I am entering a number in a field that will be a multiple of .25 - the number is automatically rounding itself up to the nearest 1 e.g. 0.75 becomes 1 - how can I stop this from happening?  Also, how can I set up ...
Score Can't find Pocket Access on my PDA
DavidRatcliff - 30 Nov 2005 12:59 PM - 3 messages
I have looked for pocket access on my WinCE PDA (VX6600), and although there are several "pocket" office products I can't find 'Pocket Access'.  Supposedly its part of the OS.  How do I start it up, or if it isn't there, ...
Score Messed up setting "Start Up"
Tom - 30 Nov 2005 12:49 PM - 3 messages
After setting up my "start up" options, I've noticed that I can't get back to change those "start up" options. The "Tools" menu is no-longer there.  I can't even use "Ctrl+F11".  If I remember, I unchecked all the ...
Score selecting row from a keyboard
alekm - 30 Nov 2005 10:26 AM - 2 messages
Hi, is there any way I can select a row in a datasheet from a keyboard ( make a row all black, selected)? Thanx alekmil ...
Score Help Please Message Box - Returning A Count of Records
Paul - 30 Nov 2005 6:35 AM - 3 messages
I have an import table, OrdersIn, that I want to be able to count the the number of records processed after the import routine is completed and have the record count returned to to a message box. Is this possible ? ...
Score Updating a calculated value
Bob B - 29 Nov 2005 10:42 PM - 15 messages
I can calculate a total value of 3 incomes and show it correctly as "total income" on the form. "total income" which is a field in file is not updated when I go to the table view it. Bob B ...
Score Switchboard
Bruce - 29 Nov 2005 9:50 PM - 3 messages
I have  an Access 97 database with a default switchboard. When I create a second switchboard the second page/form fails to appear. All the commands & arguments in the switchboard table appear correct and there are no error ...
Score SendMethodObject
VAL - 29 Nov 2005 8:23 PM - 3 messages
Why and how can Bcc work???? Please.  Please send me the event, rewritten - not explanation - I am new at this and this to me is complicated. THANK YOU. Private Sub BroadcastAll_Click() Dim stDocName As String     Dim stLinkCriteria As String ...
Score view a report
gls858 - 29 Nov 2005 7:54 PM - 2 messages
I have a database to track our employees vacation, sick days etc. There is a report that we print that shows all of the detail for the year for each employee. As you can imagine toward the end of the year this report can get pretty big. ...
Score How do I fade in bullets in Powerpoint by key click?
commoner 81 - 29 Nov 2005 6:01 PM - 2 messages
I want to control the timing of each fade in by key click. ...
Score FILTER RECORDS
SLOPES - 29 Nov 2005 4:19 PM - 3 messages
I am having trouble with filtering a query.  I would like to do a "invoice filter" like in the northwind sample database where it only prints one record at a time. i have orders that have several order details attached to them.  How can I ...
Score Does a form view displays a single record at a time?
Marylin - 29 Nov 2005 4:13 PM - 5 messages
Does the title for a report  appear in the header? ...
Score Expression in Report to change Font
Dj - 29 Nov 2005 4:03 PM - 5 messages
Can someone tell me if 1) I can use the Expression builder to change a text value's font (say color) in a report given the condition the text is equal to a certain value? 2) if so, how? I'm new to access and I this Expression Builder is something I just can't ...
Score Question about a Work Week span
Joe Cilinceon - 29 Nov 2005 3:59 PM - 5 messages
I'm trying to figure out how to setup a work week calculation. The week starts on Saturday and runs thru Friday. ...
Score Displaying MulitipleRecords on a Form
Rickp - 29 Nov 2005 3:52 PM - 2 messages
How do I set up a Form to display muliple records and how do I set up the Database record to handle up to 15 entries? ...
Score Printer Margins
Grant Baxter - 29 Nov 2005 3:16 PM - 4 messages
I'm the guy who is trying to help his friend upgrade his computers to newer computers running XP. I'm still stuck on trying to get his Access app to print his invoices properly. Specifically, the decimal point and the cents are being cut ...
Score Records overwriting?
Tom - 29 Nov 2005 2:49 PM - 3 messages
I have a command button that when clicked, gives me the next sequential number. I also have an event for the form, that when the program is started from scratch, the "RunNumber" gives me the next sequential number. I have a control named "RunNumber". ...
Score Calculating number of days
crybicki - 29 Nov 2005 2:15 PM - 6 messages
I have fields Date obtained and date (today) and I'm having difficulty geting the field days [date] - [date Obtained] to work I put [date] - [date Obtained] in Default Value Saving error : The database engine does not recognize either the field ...
Score Searching For Rules Depending On Field
SEAN DI''''ANNO - 29 Nov 2005 12:03 PM - 2 messages
(Final Part Of Loop Within a Loop) Good morning all, This is proving to be very frustating for me becasue my understanding of code is quite obviously rubbish.  I know what I want to do but don't know how to carry it out.  I was kindly given the code listed below ...
Score Trouble upsizing .mdb to .adp
JasperJA - 29 Nov 2005 9:58 AM - 2 messages
I'm am a first semester T-SQL student. My class deals with using SQL Server through Access. I have MS Office Professional 2003 and am running Windows XP Professional. I downloaded MSDE2000A.exe from microsoft.com because I was ...
Score how to connect the access to the sql
benson - 29 Nov 2005 9:48 AM - 5 messages
wo know access can connect to the sql serve made by microsoft , but i  can not get the success  ..the access .adp can connect the sql ,but i know sql server little ,  your help i s great and thank you for advance / ...
Score Subform problem
Jack Sheet - 29 Nov 2005 9:36 AM - 9 messages
Hi all, Access 97 Nearly there. I now have two tables T_Clients and T_Tasks containing autonumber primary keys ID_Clients and ID_Tasks. ID_Clients is duplicated in T_Tasks (Long Integer) with a one-to-many relationship. I have created forms F_Tasks and F_Tasks_Sub ...
Score hello
vassilis - 29 Nov 2005 8:46 AM - 13 messages
is there any way to desapear that records  arrows down on the left from a subfrom? ...
Score Access 2002 - check box in report not printing
Nathaniel Sopelario - 28 Nov 2005 10:25 PM - 2 messages
Hi, I have a database report created in Access 2003 with check boxes that does NOT print using Access 2002. The boxes appear in print view but leaves a blank column when printed. The boxes do print if I open the database in a computer with Office ...
Score text box
Miguel Vivar - 28 Nov 2005 9:12 PM - 8 messages
is there a way to write in a text box more than one answer? ...
Score Command Button ?
Tom - 28 Nov 2005 8:21 PM - 4 messages
When I click on my command button, this is the code that is run. Private Sub Command85_Click() DoCmd.GoToRecord , , acNewRec Me.RunNumber = Nz(DMax("[RunNumber]", "ABLE_Table1", "[RunDate]=Date()"), 0) + 1 Me.Dirty = False End Sub After I click, the next record comes up ready for input, however, ...
Score warning when starting access
specter - 28 Nov 2005 7:40 PM - 2 messages
just getting my feet wet how do i suppress this when opening access i get two warnings "security warning  unsafe expressions are not blocked do you want to block (y/n)" and "this file may not be safe if it contains code that was intended to ...
Score maybe finally - access.jpg (0/1)
specter - 28 Nov 2005 7:00 PM - 2 messages
i have enclosed a small jpg with two warnings i get when opening access just getting my feet wet how do i suppress this thanks to all ...
Score new to access - correction - with jpg attached - finally - access.jpg (0/1)
specter - 28 Nov 2005 6:57 PM - 4 messages
i have enclosed a small jpg with two warnings i get when opening access just getting my feet wet how do i suppress this thanks to all ...
Score New control in form design view
Miguel Vivar - 28 Nov 2005 6:39 PM - 3 messages
How can I put a new control to my form in desing view? ...
Score new to access
specter - 28 Nov 2005 6:15 PM - 2 messages
i have enclosed a small jpg with two warnings i get when opening access just getting my feet wet how do i suppress this thanks to all ...
Score Re: Please help with query criteria
Vincent Johns - 28 Nov 2005 5:13 PM - 3 messages
DaGoon wrote: You might be able to accomplish what you wish via judicious use of the "SendKeys" action, if the window that pops up doesn't expose its objects to you.  One problem with SendKeys is that, if the environment changes a ...
Score Email Data Access Page
JNariss - 28 Nov 2005 4:40 PM - 2 messages
Hello, I am trying to create a button on my Data Access Page which will simply email the page to the specified person. I added a command button on my DAP and then went into the Microsoft Script Editor and choose my newly ...
Score how to setup database that tracks expenses and sales by customer
richfm - 28 Nov 2005 4:00 PM - 10 messages
i need to track material and labor expsenses by customer contracts.  db needs to track additonal items to contracted sale as well.  what is the easiest way to do this or perhaps you can help? example - customer contracts for kitchen remodel for $10k.  Materials and ...
Score subform question
vassilis - 28 Nov 2005 4:00 PM - 8 messages
hello there im looking for a way to improve the appearance of a subform. for exaple to change the datasheet view,and make it with a tab control...control wizard always gives the same datasheet view. is it possible? thanks ...
Score Which field to include?
Jack Sheet - 28 Nov 2005 2:29 PM - 9 messages
Hi all, Access 97 I have two tables, T_Clients and T_Tasks. T_Clients has an autonumber primary key field ID_Clients T_Clients also has an indexed field ClientRef (text) (no duplicates allowed) T_Tasks has an autonumber primary key field ID_Tasks T_Tasks also has a field CLientRef (text). ...
Score Listbox Rowsource
DS - 28 Nov 2005 2:24 PM - 3 messages
I have one Listbox where I need to change the content from a command button.  On the first command button I have... Private Sub Command0_Click()      With Me.List3          .RowSource = "SELECT Menus.MenuID, Menus.MenuName, Menus.Active ...
Score Question about Cascade in Relationships
Joe Cilinceon - 28 Nov 2005 12:08 PM - 10 messages
I have several tables in a relationship and was wondering if you do a Cascade Delete how it would work. The table layout is like below: TENANT.CustNo (to several other tables such as Address, Contacts etc.) LEASES.LedgerID ( links to the LEDGER ) ...
Score Duplicates permitted but only if Null
Jack Sheet - 27 Nov 2005 9:48 PM - 2 messages
Hi all, Access 97 I want to permit duplicate entries in a field but only if Null. Simply indexing the field with duplicates not permitted does not seem quite enough, as it treats several Null entries as duplicates. What to do? ...
Score design question
vassilis - 27 Nov 2005 5:31 PM - 6 messages
goodevening i have 2 retated tables, one query will amost all fields and a form comes from that query(main form the data from the first table and subform all data from the second table). i want to input data in the first tbl(usualy a copy ...
Score DATEDIFF - THE TRUTH
POL - 27 Nov 2005 4:35 PM - 2 messages
Function STJ(ndt As Date, kdt As Date, vid As Integer) As String Dim ndden, ndmes, ndgod, kdden, kdmes, kdgod, dni, mes, god As Integer ' vid ñå âàäè  ïðè èç÷èñëÿâàíåòî - ò.Ã¥. àêî ñå íàïèøå êàòî â òð. êí. \1\ ñå ...
Score How do I open a program directly in access via a shortcut
Charles - 27 Nov 2005 4:21 PM - 5 messages
I have several database programs.  I would like to be able to open them directly from the desktop without going through the main access database screen.  Is this possible? ...
Score Changing field names
Jack Sheet - 27 Nov 2005 11:19 AM - 4 messages
Hi all Access 97 I find from trial and error (mainly error) that changing a field name in a table in a "mature" database (ie one riddled with queries and reports) is bad news because the field name change does not filter through to queries ...
Score Joining Tables Vlookup equivalent?
jjsun - 27 Nov 2005 5:59 AM - 2 messages
I have two tables. Table1: Transactions and Table2: Customers There are many transactions per customers.  There is a unique identifier "Customer ID" column in both tables.  However, there is one column in the Customers table called "Zipcode".  ...
Score Time Format
DaGoon - 27 Nov 2005 3:06 AM - 2 messages
To All, I am trying to display some data on a report. The control source is as follows: =Format("Total downtime: " & Sum([StopLength]*60/1440),"Short Time") In fortunately the data ends up being displayed as: "Total downtime: 1.9096412037037" ...
Next »