Anti Log Table from Log Tables
For my children I wanted to have practice in using log table while multiplying and dividing. For this I have a book Clark's Tables (Science Data Book) by Orient Longmans This has Log and Anti Log tables. This is what I have been using in my school days. Now this book is not easily available. I wanted to take a hard copy of the these Log and anti log tables. But I was not successful...as the paper is quite soiled. Then I made search on the net. I got a link. http://www.sosmath.com/tables/logtable/logtable.html Here I have log tables. I also would like to have Antilog tables also...which is not available in this site. How can I generate Anti Log table using this table. Any help? seena
bhattarams
excel
39879 articles. 
2 followers.
3 Replies
616 Views
Srinivasulu B wrote: > For my children I wanted to have practice in using log table while > multiplying and dividing. > For this I have a book Clark's Tables (Science Data Book) by Orient Longmans > This has Log and Anti Log tables. > This is what I have been using in my school days. > Now this book is not easily available. > I wanted to take a hard copy of the these Log and anti log tables. > But I was not successful...as the paper is quite soiled. > Then I made search on the net. > I got a link. > http://www.sosmath.com/tables/logtable/logtable.html > Here I have log tables. > I also would like to have Antilog tables also...which is not available in > this site. > How can I generate Anti Log table using this table. > Any help? > seena > > Answer in MPE.Newusers. Please do not multi-post.
smartin108In article <uM96a$mMKHA.3672@TK2MSFTNGP02.phx.gbl>, "Srinivasulu B" <bhattarams@gmail.com> wrote: > http://www.sosmath.com/tables/logtable/logtable.html I do not know what the problem is. I never had separate antilog tables through college. Even if you do need such tables, the Excel functions make it easy to generate log and antilog tables if you want to. Please explain your hang-up. Bill -- Private Profit; Public Poop! Avoid collateral windfall!
SalmonEgg= Log(2) 0.3010300 = 10^0.3010300 2 or if you prefer... = Power(10, 0.3010300) 2 = = = = = HTH Dana DeLouis Srinivasulu B wrote: > For my children I wanted to have practice in using log table while > multiplying and dividing. > For this I have a book Clark's Tables (Science Data Book) by Orient Longmans > This has Log and Anti Log tables. > This is what I have been using in my school days. > Now this book is not easily available. > I wanted to take a hard copy of the these Log and anti log tables. > But I was not successful...as the paper is quite soiled. > Then I made search on the net. > I got a link. > http://www.sosmath.com/tables/logtable/logtable.html > Here I have log tables. > I also would like to have Antilog tables also...which is not available in > this site. > How can I generate Anti Log table using this table. > Any help? > seena > >
delouis
Similar Artilces:
changing fields to another table's fields
I have made a form using fields from table#1. I want to use fields of same name from table#2. Easy way to do this? If you want to use data from table2 instead of table1 in the same form you might edit a "RowSource" property from "table1" to "table2" in a properties of your form. Denis. "sparky" <sparky@discussions.microsoft.com> �������/�������� � �������� ���������: news:9E9A7960-C5ED-44CF-85A5-0CC7FFFE8DEE@microsoft.com... >I have made a form using fields from table#1. I want to use fields of same > name from table#2. Easy way t...
Accss Tables
I have a set of Tables that are linked to Excell Sheets. My perfomance is very slow I was wondering if there is a way to take the existing linked table and convert them into local Access tables retaining the exsiting data in the tables. File | Get External Data | Import -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Harold" <anonymous@discussions.microsoft.com> wrote in message news:0BE86EEE-C2FC-4347-A056-03D6715EE46E@microsoft.com... > I have a set of Tables that are linked to Excell Sheets. My perfomance is very slow. > I was wo...
Urgent!!! e02.log deleted by Symantec Antivirus
Please help, Information Store can not mount. due to virus nestsky P I can not undeleted. How can i fix it? Urgent!!!!! Do not scan the exchsrvr dirs or M: drive. Do you have a good backup? On Sun, 13 Jun 2004 01:51:01 -0700, "boonsitc@hotmail.com" <boonsitc@hotmail.com@discussions.microsoft.com> wrote: >Please help, Information Store can not mount. due to virus nestsky P >I can not undeleted. How can i fix it? >Urgent!!!!! Restore from your last backup. -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "boonsitc@hotmai...
Pivot Table #7
Hi -- I have a pivot table Column A = Soldtoname Column B = Sales # Column C = Software Column D = Support Column E = Grand total Is there a way to incorporate next to Column E what percentage Support represents? Hi, Take a look at Debra web http://www.contextures.com/xlPivot10.html if this helps please click yes, thanks "H" wrote: > Hi -- I have a pivot table > > Column A = Soldtoname > Column B = Sales # > Column C = Software > Column D = Support > Column E = Grand total > > Is there a way to incorporate next to Column E what percentage Supp...
Log files on wrong drive
Hi, Exchange 2000 SP3. I've moved my database and streaming file locations in System Manager to drive F: They have moved okay but the log files are still writing on C: Is this to be expected and how can I change that location as well? Thanks, Peter The log file location is found on the properties of the Storage Group. Change it there, and it will automatically move them for you. Note that when you move the log files, it will have to dismount any databases that are using them while it moves the log files. -- Ben Winzenz Exchange MVP MessageOne Read my blog! http://winzenz.blogspot...
cannot open excel file
I go to open an excel spreadsheet that was working perfectly fine on Friday (it is now Monday), and I get the following error message (regardless of Macro settings): "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." I did a search of all "*.log" files on my computer, and the only one modified at the same time as the error is drwtsn32.log. Here's the entry I get from the log file: "Application exception occurred: App: (pid=624) When: 6/6/2005 @ 10:28:51.290 ...
Adding row to a table
I have appreciated the input of g. mayor and have found his "An alternative method of adding a row to a protected table" (http://www.gmayor.com/word_vba_examples.htm) to be quite helpful. It is designed to be an 'exit macro' and I am trying to use it in a slightly different way. My issue is that as a user tabs through a form they will always come to the last cell and tabbing to the next formfield just creates another row. So I am attempting to set up a button (commandbutton) that will run the macro and add an additional row 'on demand.' I have this...
find affected tables when creating a new record in CRM frontend
How can I find out what tables which new record has been added on when I enter data through a form in CRM front end? I try to find way to map form in the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0 Thank in advances for help! On Nov 9, 12:12=A0pm, VistaUser123 <sunmapleleaf...@yahoo.com> wrote: > How can I find out what tables which new record has been added on when I > enter data through a form in CRM front end? I try to find way to map form= in > the CRM frontend to the tables at the CRM database at backend? It is CRM = 3.0 > > Thank in...
Pivot Table Basics
I am almost certain that I can use pivot tables to make life easier, but have no idea where to start. My understanding is that data on a worksheet can be used more comprehensively using one of these. Can someone point me in the direction of a BASIC lesson on Pivot Tables, in order that I can explore the possibility of using one? Let's say I have a worksheet with column headings and data under each heading....Let's also say that I have no idea what a pivot table is used for! Many thanks! Manhar There are pivot table instructions and links on Jon Peltier's web site: ...
Comparing two tables
hey just a short question :-D I have two tables, one with a list with 1330 entries and one with 720 entries, the 720 are all in the big list as well, is there a way to write the 610 entries from the big list that arent in the small list into another excel table without doing it one by one ? thanks in advance Peter PEter, try to use the "VLOOKUP" function...it will help you to identify with values are in both tables (sheets)... so you can mark the values that are in both tables and separete then easily... i don´t know if you know the VLOOKUP function...if you don´...
Reorient Pivot Table Data
Hello, Is it possible to reorient pivot table Data from rows to columns? An example is as follows: Now (data is correct) TYPE SUBTYPE DATA A 1 Permits 5 Value $1,500,258 Lots 25 A 2 Permits 3 Value $1,253,000 Lots 12 ================================================================== To This: TYPE SUBTYPE Permits Value Lots A 1 5 $1,500,258 25 A 2 3 $1,253,000 12 Thanks, JBESr To arrange the data fields horizontally, drag the Data button onto the cell that contains the word Total. There's a screen shot here: http://www.contextures.com/x...
LOG Files #3
How can read the log files generated on my server? Is there a Log reader utilty? The logs are not simple text files. Example "E0000004.log" they are not meant to be read, really...those are your transaction log files... "Lee" <Lee@discussions.microsoft.com> wrote in message news:DF36C762-AA2B-4623-BE66-1656F9316903@microsoft.com... > How can read the log files generated on my server? Is there a Log reader > utilty? The logs are not simple text files. > > Example "E0000004.log" Well the problem is that I have had an "Explosion" of ...
Ole objects in records/tables
I have a question every time I tried to go to word and powerpoint and says type a prodect key I typed from the back of my labtop but it keeps saying it wrong.So what do I do? WHAT??????? "Kevin Ramos" <kevin's email> wrote in message news:%23X$8BdeQIHA.2268@TK2MSFTNGP02.phx.gbl... >I have a question every time I tried to go to word and powerpoint and says >type a prodect key I typed from the back of my labtop but it keeps saying >it wrong.So what do I do? ...
Anti-virus necessary on front end server?
I'm currently running Symantec Anti-virus for Exchange on my Exchange 2003 back-end server. I'm adding a front-end server to be used for OWA, POP3, and IMAP send/receive access. The server will have a store (for the direct POP3 and IMAP connectivity), but no mailboxes on it. Will I require anti-virus on this server as well as my back-end? I can't find any real recommendations on this. Thanks in advance. Paul On Thu, 20 Apr 2006 12:59:47 -0400, "Paul" <paul@nodomain.com> wrote: >I'm currently running Symantec Anti-virus for Exchange on my Exchange...
logging password changes
Is it possible to audit when a user changes their Great Plains password and then get a report on this. -- Doug Wilson Great Plains Consultant MCS Canada Are you using SQL Server? If so, I think turning on the C2 security option will audit these changes. "Doug" <Doug@discussions.microsoft.com> wrote in message news:C0DF7B95-6D10-43B1-817C-063CFA4B0ACE@microsoft.com... > Is it possible to audit when a user changes their Great Plains password > and > then get a report on this. > -- > Doug Wilson > Great Plains Consultant > MCS Canada ...
HR & Payroll Table Security
How can we grant read/write access to only the SQL tables for HR and payroll. We do not want to have a GP user setup, only SQL access. You would use Enterprise Manager or Management Studio to create a login; assign the login to the database; and (here's the tricky part) select the specific tables you want the user to see. For payroll tables, select the UPR tables. For the HR tables, you'll need to assign permissions to tables with various types of names. Use the Resource Descriptions in GP to look at the HR tables so you will know which ones you need. -- Charles Allen, MVP ...
Delete rows in table if checkbox value in first cell equals true
Hi People, First time caller long time observer. I'm creating a form which contains three tables. First two tables contain information such as heading, date, time, user details etc. Table three consists of 2 rows and 5 columns. First row is used for column headings and second row contains form fields where the user can record their data. The first cell of row 2 contains a checkbox and the rest contain text fields. Now, I would like the user to have the ability to add and remove rows at click of a button. After couple hours of researching I figured out the code that...
GetSaveAsFilename
When a user closes a workbook I want my macro to retrieve the username logged in to the machine and use that as the filename. Is this possible? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ In a general module: Option Explicit Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As L...
Updating table/list
I have a quarterly report of company names and tables of other data related to it. My problem is every quarter, the company names changes (dropped some, added some). For 2 qtrs now, I have just created a new table with the new list and deleted the old table. This Company List table has relationships. Is there an easier way of updating the company list without having to delete, and re-create table? My data comes from an excel spreadsheet which is exported from Access. Thanks for any help. ...
log files #6
Hi, On the last installations of 2003SBS premium SP1 edition, i noticed that under c:\program files\exchsrv\mdbdata\, lots of .log-files are created, consuming lots of space. Is there a way to avoid the creation of these files. Because after, lets say a week, these files can consume for example 3Gb ! and these are the things that are eating up my diskspace. Regards, Jo Lambrecht I think the way is scheduled job on 00:00 I think: cd c:\program files\exchsrv\mbdata del *.log /q "Jo Lambrecht" wrote: > Hi, > > On the last installations of 2003SBS premium SP1 edi...
Look up wizard in tables
I have designed a table and in one field of the table I have used 'look up wizard' to make a relationship with another table in the database. When I open the table in datasheet view and click on the field with the 'Look up relationship' it pulls information from the first column only, not the second. The relationship of the tables are right, not sure why it is pulling information from one column only. I would like it to pull from both columns as the row information is related. IMO, you should never ever use lookup fields in table designs. http://www.mvps.org/acc...
Adding additional column of data to pivot table
I have a data table that has 7000 rows, which I'm slicing using a pivot table. Column A has 150 unique values. I'd like to add another pivot table field (let's call it field F), which will have three unique values. I will decide which of the Column A values should match up to three field F values. Obviously, I don't want to do this for 7000 rows but just for the 150 unique Column A rows. Can someone tell me what the best way is to do this? In database theory, I guess what I want is to create another table and then join them, but I'm not sure if that is common in Excel. H...
anti virus help
can anyone direct me in a good direction?? i'm looking to find a good and simple anti-virus for exchange. mabey a free trial to test it out? thanks for your opinions. Trend ScanMail or Antigen are the usual favourites. -- Neil Hobson Exchange MVP http://www.msexchange.org/Neil_Hobson/ http://www.msexchangeblog.com "tmolaee" <tmolaee@discussions.microsoft.com> wrote in message news:4B2F78DD-E555-49DF-A466-918EEC5E816F@microsoft.com... > can anyone direct me in a good direction?? i'm looking to find a good and > simple anti-virus for exchange. mabey a free t...
Pivot Table #43
One of the row headings in my pivot Table is 'Ticker'. On the data page there are about 12 rows with a ticker of 'GS'. These willl NOT show up on the pivot table. If I change them to something else (GS_TEST,GS_TEMP, etc) and refresh the pivot table, they appear. When I try to change the ticker back to GS and refresh, they disappear again.. Thoughts?? I've been all over the knowledge base.. Looked up smart tags, checked my autocorrect entries, etc.. I don't know of anything that would cause the problem. If you copy the source data into a new workbook, and crea...
Linking fields in different table in same database
I have a database (Access 2007) that is used for holding data on and communicating with FE colleges. Obviously (?) each college has a number of contacts (up to 14) and these are represented in two tables – one for College Details and one for Contact Details which are linked by a one to many relationship. Most colleges have one representative on one of 3 groups, but not all colleges are represented on all groups and some not on any. The membership of a group is noted by a field in the Contact details. Getting a query to run to identify membership of groups is OK. But I can’t fig...
I have made a form using fields from table#1. I want to use fields of same name from table#2. Easy way to do this? If you want to use data from table2 instead of table1 in the same form you might edit a "RowSource" property from "table1" to "table2" in a properties of your form. Denis. "sparky" <sparky@discussions.microsoft.com> �������/�������� � �������� ���������: news:9E9A7960-C5ED-44CF-85A5-0CC7FFFE8DEE@microsoft.com... >I have made a form using fields from table#1. I want to use fields of same > name from table#2. Easy way t...
Accss Tables
I have a set of Tables that are linked to Excell Sheets. My perfomance is very slow I was wondering if there is a way to take the existing linked table and convert them into local Access tables retaining the exsiting data in the tables. File | Get External Data | Import -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Harold" <anonymous@discussions.microsoft.com> wrote in message news:0BE86EEE-C2FC-4347-A056-03D6715EE46E@microsoft.com... > I have a set of Tables that are linked to Excell Sheets. My perfomance is very slow. > I was wo...
Urgent!!! e02.log deleted by Symantec Antivirus
Please help, Information Store can not mount. due to virus nestsky P I can not undeleted. How can i fix it? Urgent!!!!! Do not scan the exchsrvr dirs or M: drive. Do you have a good backup? On Sun, 13 Jun 2004 01:51:01 -0700, "boonsitc@hotmail.com" <boonsitc@hotmail.com@discussions.microsoft.com> wrote: >Please help, Information Store can not mount. due to virus nestsky P >I can not undeleted. How can i fix it? >Urgent!!!!! Restore from your last backup. -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "boonsitc@hotmai...
Pivot Table #7
Hi -- I have a pivot table Column A = Soldtoname Column B = Sales # Column C = Software Column D = Support Column E = Grand total Is there a way to incorporate next to Column E what percentage Support represents? Hi, Take a look at Debra web http://www.contextures.com/xlPivot10.html if this helps please click yes, thanks "H" wrote: > Hi -- I have a pivot table > > Column A = Soldtoname > Column B = Sales # > Column C = Software > Column D = Support > Column E = Grand total > > Is there a way to incorporate next to Column E what percentage Supp...
Log files on wrong drive
Hi, Exchange 2000 SP3. I've moved my database and streaming file locations in System Manager to drive F: They have moved okay but the log files are still writing on C: Is this to be expected and how can I change that location as well? Thanks, Peter The log file location is found on the properties of the Storage Group. Change it there, and it will automatically move them for you. Note that when you move the log files, it will have to dismount any databases that are using them while it moves the log files. -- Ben Winzenz Exchange MVP MessageOne Read my blog! http://winzenz.blogspot...
cannot open excel file
I go to open an excel spreadsheet that was working perfectly fine on Friday (it is now Monday), and I get the following error message (regardless of Macro settings): "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." I did a search of all "*.log" files on my computer, and the only one modified at the same time as the error is drwtsn32.log. Here's the entry I get from the log file: "Application exception occurred: App: (pid=624) When: 6/6/2005 @ 10:28:51.290 ...
Adding row to a table
I have appreciated the input of g. mayor and have found his "An alternative method of adding a row to a protected table" (http://www.gmayor.com/word_vba_examples.htm) to be quite helpful. It is designed to be an 'exit macro' and I am trying to use it in a slightly different way. My issue is that as a user tabs through a form they will always come to the last cell and tabbing to the next formfield just creates another row. So I am attempting to set up a button (commandbutton) that will run the macro and add an additional row 'on demand.' I have this...
find affected tables when creating a new record in CRM frontend
How can I find out what tables which new record has been added on when I enter data through a form in CRM front end? I try to find way to map form in the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0 Thank in advances for help! On Nov 9, 12:12=A0pm, VistaUser123 <sunmapleleaf...@yahoo.com> wrote: > How can I find out what tables which new record has been added on when I > enter data through a form in CRM front end? I try to find way to map form= in > the CRM frontend to the tables at the CRM database at backend? It is CRM = 3.0 > > Thank in...
Pivot Table Basics
I am almost certain that I can use pivot tables to make life easier, but have no idea where to start. My understanding is that data on a worksheet can be used more comprehensively using one of these. Can someone point me in the direction of a BASIC lesson on Pivot Tables, in order that I can explore the possibility of using one? Let's say I have a worksheet with column headings and data under each heading....Let's also say that I have no idea what a pivot table is used for! Many thanks! Manhar There are pivot table instructions and links on Jon Peltier's web site: ...
Comparing two tables
hey just a short question :-D I have two tables, one with a list with 1330 entries and one with 720 entries, the 720 are all in the big list as well, is there a way to write the 610 entries from the big list that arent in the small list into another excel table without doing it one by one ? thanks in advance Peter PEter, try to use the "VLOOKUP" function...it will help you to identify with values are in both tables (sheets)... so you can mark the values that are in both tables and separete then easily... i don´t know if you know the VLOOKUP function...if you don´...
Reorient Pivot Table Data
Hello, Is it possible to reorient pivot table Data from rows to columns? An example is as follows: Now (data is correct) TYPE SUBTYPE DATA A 1 Permits 5 Value $1,500,258 Lots 25 A 2 Permits 3 Value $1,253,000 Lots 12 ================================================================== To This: TYPE SUBTYPE Permits Value Lots A 1 5 $1,500,258 25 A 2 3 $1,253,000 12 Thanks, JBESr To arrange the data fields horizontally, drag the Data button onto the cell that contains the word Total. There's a screen shot here: http://www.contextures.com/x...
LOG Files #3
How can read the log files generated on my server? Is there a Log reader utilty? The logs are not simple text files. Example "E0000004.log" they are not meant to be read, really...those are your transaction log files... "Lee" <Lee@discussions.microsoft.com> wrote in message news:DF36C762-AA2B-4623-BE66-1656F9316903@microsoft.com... > How can read the log files generated on my server? Is there a Log reader > utilty? The logs are not simple text files. > > Example "E0000004.log" Well the problem is that I have had an "Explosion" of ...
Ole objects in records/tables
I have a question every time I tried to go to word and powerpoint and says type a prodect key I typed from the back of my labtop but it keeps saying it wrong.So what do I do? WHAT??????? "Kevin Ramos" <kevin's email> wrote in message news:%23X$8BdeQIHA.2268@TK2MSFTNGP02.phx.gbl... >I have a question every time I tried to go to word and powerpoint and says >type a prodect key I typed from the back of my labtop but it keeps saying >it wrong.So what do I do? ...
Anti-virus necessary on front end server?
I'm currently running Symantec Anti-virus for Exchange on my Exchange 2003 back-end server. I'm adding a front-end server to be used for OWA, POP3, and IMAP send/receive access. The server will have a store (for the direct POP3 and IMAP connectivity), but no mailboxes on it. Will I require anti-virus on this server as well as my back-end? I can't find any real recommendations on this. Thanks in advance. Paul On Thu, 20 Apr 2006 12:59:47 -0400, "Paul" <paul@nodomain.com> wrote: >I'm currently running Symantec Anti-virus for Exchange on my Exchange...
logging password changes
Is it possible to audit when a user changes their Great Plains password and then get a report on this. -- Doug Wilson Great Plains Consultant MCS Canada Are you using SQL Server? If so, I think turning on the C2 security option will audit these changes. "Doug" <Doug@discussions.microsoft.com> wrote in message news:C0DF7B95-6D10-43B1-817C-063CFA4B0ACE@microsoft.com... > Is it possible to audit when a user changes their Great Plains password > and > then get a report on this. > -- > Doug Wilson > Great Plains Consultant > MCS Canada ...
HR & Payroll Table Security
How can we grant read/write access to only the SQL tables for HR and payroll. We do not want to have a GP user setup, only SQL access. You would use Enterprise Manager or Management Studio to create a login; assign the login to the database; and (here's the tricky part) select the specific tables you want the user to see. For payroll tables, select the UPR tables. For the HR tables, you'll need to assign permissions to tables with various types of names. Use the Resource Descriptions in GP to look at the HR tables so you will know which ones you need. -- Charles Allen, MVP ...
Delete rows in table if checkbox value in first cell equals true
Hi People, First time caller long time observer. I'm creating a form which contains three tables. First two tables contain information such as heading, date, time, user details etc. Table three consists of 2 rows and 5 columns. First row is used for column headings and second row contains form fields where the user can record their data. The first cell of row 2 contains a checkbox and the rest contain text fields. Now, I would like the user to have the ability to add and remove rows at click of a button. After couple hours of researching I figured out the code that...
GetSaveAsFilename
When a user closes a workbook I want my macro to retrieve the username logged in to the machine and use that as the filename. Is this possible? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ In a general module: Option Explicit Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As L...
Updating table/list
I have a quarterly report of company names and tables of other data related to it. My problem is every quarter, the company names changes (dropped some, added some). For 2 qtrs now, I have just created a new table with the new list and deleted the old table. This Company List table has relationships. Is there an easier way of updating the company list without having to delete, and re-create table? My data comes from an excel spreadsheet which is exported from Access. Thanks for any help. ...
log files #6
Hi, On the last installations of 2003SBS premium SP1 edition, i noticed that under c:\program files\exchsrv\mdbdata\, lots of .log-files are created, consuming lots of space. Is there a way to avoid the creation of these files. Because after, lets say a week, these files can consume for example 3Gb ! and these are the things that are eating up my diskspace. Regards, Jo Lambrecht I think the way is scheduled job on 00:00 I think: cd c:\program files\exchsrv\mbdata del *.log /q "Jo Lambrecht" wrote: > Hi, > > On the last installations of 2003SBS premium SP1 edi...
Look up wizard in tables
I have designed a table and in one field of the table I have used 'look up wizard' to make a relationship with another table in the database. When I open the table in datasheet view and click on the field with the 'Look up relationship' it pulls information from the first column only, not the second. The relationship of the tables are right, not sure why it is pulling information from one column only. I would like it to pull from both columns as the row information is related. IMO, you should never ever use lookup fields in table designs. http://www.mvps.org/acc...
Adding additional column of data to pivot table
I have a data table that has 7000 rows, which I'm slicing using a pivot table. Column A has 150 unique values. I'd like to add another pivot table field (let's call it field F), which will have three unique values. I will decide which of the Column A values should match up to three field F values. Obviously, I don't want to do this for 7000 rows but just for the 150 unique Column A rows. Can someone tell me what the best way is to do this? In database theory, I guess what I want is to create another table and then join them, but I'm not sure if that is common in Excel. H...
anti virus help
can anyone direct me in a good direction?? i'm looking to find a good and simple anti-virus for exchange. mabey a free trial to test it out? thanks for your opinions. Trend ScanMail or Antigen are the usual favourites. -- Neil Hobson Exchange MVP http://www.msexchange.org/Neil_Hobson/ http://www.msexchangeblog.com "tmolaee" <tmolaee@discussions.microsoft.com> wrote in message news:4B2F78DD-E555-49DF-A466-918EEC5E816F@microsoft.com... > can anyone direct me in a good direction?? i'm looking to find a good and > simple anti-virus for exchange. mabey a free t...
Pivot Table #43
One of the row headings in my pivot Table is 'Ticker'. On the data page there are about 12 rows with a ticker of 'GS'. These willl NOT show up on the pivot table. If I change them to something else (GS_TEST,GS_TEMP, etc) and refresh the pivot table, they appear. When I try to change the ticker back to GS and refresh, they disappear again.. Thoughts?? I've been all over the knowledge base.. Looked up smart tags, checked my autocorrect entries, etc.. I don't know of anything that would cause the problem. If you copy the source data into a new workbook, and crea...
Linking fields in different table in same database
I have a database (Access 2007) that is used for holding data on and communicating with FE colleges. Obviously (?) each college has a number of contacts (up to 14) and these are represented in two tables – one for College Details and one for Contact Details which are linked by a one to many relationship. Most colleges have one representative on one of 3 groups, but not all colleges are represented on all groups and some not on any. The membership of a group is noted by a field in the Contact details. Getting a query to run to identify membership of groups is OK. But I can’t fig...