Calculating Columns
how do you create a formula using data tables calculate each divide each (3) quiz by 100 times .01 times 10%, each (2)test by 100 times .01 times 35% to get the final %
Answer Question
| February 27, 2012 11:18 PM
Microsoft Excel, Microsoft Windows Vista
how do you create a formula using data tables calculate each divide each (3) quiz by 100 times .01 times 10%, each (2)test by 100 times .01 times 35% to get the final %
Answer Question
| February 27, 2012 11:18 PM
Microsoft Excel, Microsoft Windows Vista
Off site printing
I have two locations that have a unique requiement. Both use peer to peer networks and require to be able to print documents that have been created on a data base at the other location. Example: database at location A and needs to print invoice at location B, database at location B needs to print [...]
Answer Question
| February 27, 2012 10:58 PM
Microsoft Windows XP, Peer-to-Peer Networks, Windows 7
I have two locations that have a unique requiement. Both use peer to peer networks and require to be able to print documents that have been created on a data base at the other location. Example: database at location A and needs to print invoice at location B, database at location B needs to print [...]
Answer Question
| February 27, 2012 10:58 PM
Microsoft Windows XP, Peer-to-Peer Networks, Windows 7
access 2003 complex query
Master table has fields: Report_No,Product_ID,Test_Date Detail table has fields: Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result Results table has records: Pass,Fail,R&D,InProcess Detail table have 1,2 or 3 records with different result against each record in Master table. I want to create a query to count Reports from master having Results=Pass, Fail, R&D, InProcess and Mix i-e one Report can contains [...]
Answer Question
| February 27, 2012 7:19 PM
Microsoft Access 2003, Microsoft Access 2003 forms
Master table has fields: Report_No,Product_ID,Test_Date Detail table has fields: Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result Results table has records: Pass,Fail,R&D,InProcess Detail table have 1,2 or 3 records with different result against each record in Master table. I want to create a query to count Reports from master having Results=Pass, Fail, R&D, InProcess and Mix i-e one Report can contains [...]
Answer Question
| February 27, 2012 7:19 PM
Microsoft Access 2003, Microsoft Access 2003 forms
No Authorisation in creating a Role
Hi, I’ve created a new client (501). Copied “SAP USER MAster” profile (not SAP_ALL) from client 000 to this new client (501). I created a master user (with SAP_ALL & SAP_NEW) in 501. Then I created another user “BASIS” without assigning any profile to it while creation. Now, for the user “basis”, I created a [...]
Answer Question
| March 29, 2012 1:05 PM
SAP Basis Administrator, SAP errors
Hi, I’ve created a new client (501). Copied “SAP USER MAster” profile (not SAP_ALL) from client 000 to this new client (501). I created a master user (with SAP_ALL & SAP_NEW) in 501. Then I created another user “BASIS” without assigning any profile to it while creation. Now, for the user “basis”, I created a [...]
Answer Question
| March 29, 2012 1:05 PM
SAP Basis Administrator, SAP errors
vb6 using parameter
hi to everyone…. i need help on how to become a good programmer,,, i have a question,,,, are all codes in creating a program can be found on internet??? or ineed a reference book…. no i start in vb6 and ms access…. please give me an advise and relevant website to supply my ambition to [...]
Answer Question
| March 1, 2012 11:46 AM
Microsoft Access, Visual Basic 6.0
hi to everyone…. i need help on how to become a good programmer,,, i have a question,,,, are all codes in creating a program can be found on internet??? or ineed a reference book…. no i start in vb6 and ms access…. please give me an advise and relevant website to supply my ambition to [...]
Answer Question
| March 1, 2012 11:46 AM
Microsoft Access, Visual Basic 6.0
How to find the Max point on a curve in AutoCAD 2011
How can I find the maximum point of a curve(spline) in AutoCad 2011? Yours,Etc.
Answer Question
| February 27, 2012 11:35 AM
AutoCAD 2011, AutoCAD Attributes
How can I find the maximum point of a curve(spline) in AutoCad 2011? Yours,Etc.
Answer Question
| February 27, 2012 11:35 AM
AutoCAD 2011, AutoCAD Attributes
Java CSV reader (+charts)
Hello there, I’m trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter
Answer Question
| May 15, 2013 12:03 AM
.CSV files, Eclipse, Java, MySQL
Hello there, I’m trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter
Answer Question
| May 15, 2013 12:03 AM
.CSV files, Eclipse, Java, MySQL
Calcing quartiles using the median
I’m using this SQL to determine the median of a group of temperatures… select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end) >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2 + 1 If I want the 1st [...]
Answer Question
| March 17, 2012 11:04 PM
IBM i, SQL
I’m using this SQL to determine the median of a group of temperatures… select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end) >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2 + 1 If I want the 1st [...]
Answer Question
| March 17, 2012 11:04 PM
IBM i, SQL
VLookUp
In a vlookup, what do I type in the formula so it shows “err” or something that indicates that the EXACT match is not found in the table?
Answer Question
| February 27, 2012 8:55 PM
Exact match VLookUp, VLOOKUP function
In a vlookup, what do I type in the formula so it shows “err” or something that indicates that the EXACT match is not found in the table?
Answer Question
| February 27, 2012 8:55 PM
Exact match VLookUp, VLOOKUP function
Iseries HMC
How to clear event logs using v7.7.4 SP1 would like command line information
Answer Question
| March 17, 2012 5:58 PM
HMC, HMC Event logs
How to clear event logs using v7.7.4 SP1 would like command line information
Answer Question
| March 17, 2012 5:58 PM
HMC, HMC Event logs
Best IT Certifications
What certification is on this list that you wish you had but haven’t gotten around to getting it yet?http://bit.ly/zI0N4r
Answer Question
| March 7, 2012 5:49 PM
IT certification
What certification is on this list that you wish you had but haven’t gotten around to getting it yet?http://bit.ly/zI0N4r
Answer Question
| March 7, 2012 5:49 PM
IT certification
access denied when searching
Hello!! My company has Server2008 R2 environment. XP and 7 clients. 7 clients are working with Folder redirection, XP clients are roaming profile. There is a problem while searching on mapped drive, its asking for permissions. The issue is only on 7, not on XP clients. There are 2 folders on this mapped drive that [...]
Answer Question
| February 27, 2012 4:55 PM
Windows 7, Windows Server 2008 R2, Windows XP
Hello!! My company has Server2008 R2 environment. XP and 7 clients. 7 clients are working with Folder redirection, XP clients are roaming profile. There is a problem while searching on mapped drive, its asking for permissions. The issue is only on 7, not on XP clients. There are 2 folders on this mapped drive that [...]
Answer Question
| February 27, 2012 4:55 PM
Windows 7, Windows Server 2008 R2, Windows XP
barcode entered, still dlookup not populating “item” and “price” in the form
I have two tables, one is “inventory” and the other is “sale”. I created form using the fields from “sale”. in the “inventory” table, I saved barcodes of all items. Here, I want the form to populate the “item” name and “price” of the barcode I enter in the barcode textbox of the form. Currenty, [...]
Answer Question
| February 27, 2012 9:40 AM
Microsoft Access, Microsoft Access forms
I have two tables, one is “inventory” and the other is “sale”. I created form using the fields from “sale”. in the “inventory” table, I saved barcodes of all items. Here, I want the form to populate the “item” name and “price” of the barcode I enter in the barcode textbox of the form. Currenty, [...]
Answer Question
| February 27, 2012 9:40 AM
Microsoft Access, Microsoft Access forms
email is being received multiple times in a period of 2 days
the person is recieving her email onto her phone via Exchange server. She has been complaining that she is recieving the same mail multiple times over a period of 2 days. Any help?
Answer Question
| February 27, 2012 8:07 AM
Exchange, Microsoft Exchange errors
the person is recieving her email onto her phone via Exchange server. She has been complaining that she is recieving the same mail multiple times over a period of 2 days. Any help?
Answer Question
| February 27, 2012 8:07 AM
Exchange, Microsoft Exchange errors
sqlrpgle-6
query to find n’th Highest salary in a file?
Answer Question
| March 17, 2012 6:56 AM
AS/400, SQLRPGLE
query to find n’th Highest salary in a file?
Answer Question
| March 17, 2012 6:56 AM
AS/400, SQLRPGLE
How to Fix OST Outlook 2010?
Follow Microsoft recommendations or buy rights to use a 3rd-party product.
Answer Question
| July 5, 2012 4:41 AM
Exchange Server, Microsoft Outlook 2010
Follow Microsoft recommendations or buy rights to use a 3rd-party product.
Answer Question
| July 5, 2012 4:41 AM
Exchange Server, Microsoft Outlook 2010
Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
Answer Question
| May 8, 2013 11:45 PM
CSV, SQL Jobs, SSMS 2008
how to get to print setup when printserver is defaulted to?
how to get to print setup when printserver is defaulted to? Setting up several z400m and one of them, when attaching to the web interface ONLY gives ZebraNet print server and no way to get to the z400m printer configuration via the web interface. Brand new out of the box.
Answer Question
| March 17, 2012 9:02 PM
Printer Configuration, Zebra ZM400
how to get to print setup when printserver is defaulted to? Setting up several z400m and one of them, when attaching to the web interface ONLY gives ZebraNet print server and no way to get to the z400m printer configuration via the web interface. Brand new out of the box.
Answer Question
| March 17, 2012 9:02 PM
Printer Configuration, Zebra ZM400
Multiple same condition types with different values for a line item
We are having a generic service product at item level and to this item we are having a list of products in the products list tab. The requirement is to price the service line item for each of these products. eg; Service line item is for service material ‘Maintenance’ Product attached to this line item [...]
Answer Question
| February 27, 2012 8:40 PM
CRM 7.0, SAP
We are having a generic service product at item level and to this item we are having a list of products in the products list tab. The requirement is to price the service line item for each of these products. eg; Service line item is for service material ‘Maintenance’ Product attached to this line item [...]
Answer Question
| February 27, 2012 8:40 PM
CRM 7.0, SAP
Searching for a TechTarget member profile
Hopefully this is a simple question: I’m trying to to track down a TechTarget member that had assisted me with an networking issue some time ago, but now I can’t seem to locate any of their posts. I remember a portion of their handle, but not all of it. Is there anyway to search member [...]
Answer Question
| February 27, 2012 8:27 PM
Techtarget
Hopefully this is a simple question: I’m trying to to track down a TechTarget member that had assisted me with an networking issue some time ago, but now I can’t seem to locate any of their posts. I remember a portion of their handle, but not all of it. Is there anyway to search member [...]
Answer Question
| February 27, 2012 8:27 PM
Techtarget
