SQL Query to consolidate rows into new table
You could create your new table from a query similar to this: <pre>SELECT time, SUM(IIF(type=”BID”,price,0)) AS bid_price, SUM(IIF(type=”ASK”,price,0)) AS ask_price,code FROM your_table GROUP BY time,code </pre> This is Access syntax (you tagged the question with ‘Access’ <b>AND </b>’SQlite’, so we don’t really know what you are using).

View Answer   |  August 11, 2010  4:06 PM
Access, SQL, SQL Query, SQLite

SQL Query to get the difference from average for every row with grouping
You could use an in-line view, but I’m not sure if this is supported on SQlite. Something like this: <pre>SELECT y.region, y.id, m.mean-y.cost AS dif_from_mean FROM your_table y JOIN (SELECT region, AVG(cost) mean FROM your_table GROUP BY region) m ON y.region = m.region;</pre>

View Answer   |  August 11, 2010  2:15 PM
Access, SQL, SQL Query, SQLite

How do I duplicate or clone a dying SATA drive?
Regardless of the type of drive, SATA, IDE etc.. I have always used the Unix tool “dd” for duplicating data. This is awesome when it comes to taking data from a source drive to another drive or even backup image file. There are a couple of things to bear in mind though when using dd. [...]

View Answer   |  August 10, 2010  3:52 PM
Backup, Clone database, IDE, IDE hard drives, SATA, SATA Drives, SCSI, SCSI Drives

Entry Level IT Job
I guess it depends on what you study and what you would like to do

View Answer   |  August 9, 2010  3:04 AM
IT career development, IT career planning, IT careers

How to remove Microsoft Foxpro Title bar
You can remove title bar from a form by setting the following properties in property window: Set the Caption property to “” Set the ControlBox property to .F. Set the MaxButton property to .F. Set the MinButton property to .F. Set the Movable property to .F. Hope it will solve your problem

View Answer   |  August 3, 2010  5:14 AM
FoxPro, FoxPro 2.6, FoxPro 2.6 for WINDOWS

How to enter a field with number increments in Access 2007
if this field is going to increment with the same unit then try to make that field as auto increment field in database.

View Answer   |  August 3, 2010  5:07 AM
Access 2007, Access 2007 forms, Access 2007 functions

Can’t change Navigation Button Caption for subform
You have to open the sub-form in a new window. Microsoft will not allow you to change it through a sub-form. Hope that answers your question.

View Answer   |  July 31, 2010  3:05 AM
Access 2007, Access forms, Microsoft Access

Error message stating that the value is too long for the field.
Are you using Access 97 or earlier? This error occurs if one of the fields in the record has a default value that exceeds that field’s FieldSize property setting. Increase the field’s FieldSize property setting to be equal to or larger than the field’s default value. Or, change the field’s default value so that it [...]

View Answer   |  July 30, 2010  3:21 PM
Access 2007, Access errors, Error Messages

Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2
Here’s the closest thing I can find for you for best practice for <a href=”http://www.hds.com/assets/pdf/oracle-10gr2-databases-on-hitachi-nas-platform-wp.pdf “>Oracle on HDS platforms</a>.

View Answer   |  July 29, 2010  8:34 PM
Database mirroring, HDS 9960, OLTP in Oracle, Oracle 10g, RAID, RAID configuration

Should I Follow Cisco or Microsoft Career
I guess in the end it is preference of what you want to do. if you love networks then do Cisco, but if you are into microsoft products do microsoft cert. just to share that last time my friend actually did both certs at once. he did CCNA and MCSE together at a same time [...]

View Answer   |  July 29, 2010  12:27 PM
IT career development, IT career planning, IT careers, IT certification

Gently Close a Database Application
The only option I can think of would be to use AutoIT to “learn” the steps to close the program like a user would. Then save this script in executable mode when you have tested it. Then schedule this executable via Task Manager to shutdown program prior to shutdown of system.

View Answer   |  July 28, 2010  8:35 PM
Database applications, Windows XP SP3, WorldShip

Access Tab Control Problem
Actually, I had the same problem. Thanks to Roger Carlson at http://www.utteraccess.com/forum/reference-text-box-sub-t1768698.html I finally fixed it! For some reason access may have renamed your subform when you moved it onto tabs to “Child##” where ## is some random number. Double-check that’s the problem. I’ll bet it is. You don’t have to name a tab control [...]

View Answer   |  July 28, 2010  2:35 PM
Access 2007 forms, Access Forms Database, Microsoft Access 2007

Moving Cursor Within That particular field?
Help me, I don’t understand Your program is using DSPATR(PC)? on the marks field? When screen is displayed, cursor is in the first position of the marks field. Is that OK? What does the user do? Type one letter and press enter? What should happen. Screen with typed letter is displayed but cursor is in [...]

View Answer   |  July 28, 2010  8:44 AM
Cursor operation, Display File, Display File Description, DSPF

Alternative for LEFT OUTER JOIN
<pre> <li><ol> <ul></ul></ol></li></pre>

View Answer   |  July 28, 2010  5:06 AM
LEFT JOIN, LEFT OUTER JOIN statement, SQL Left Outer Join, SQL statements

Changing Access form properties within your program.
Use AfterUpdate event procedure in VBA. Check the value in combo box and set for the control property Enable=FALSE, otherwise set Enable=TRUE.

View Answer   |  July 27, 2010  6:36 PM
Access, Access form controls, Access forms, Access Forms Database

How To get The Cursor position on particular field?
The display attribute DSPATR(PC) position cursor might be what you’re after It would be placed as a keyword for the input field, on the same line as the input field If you want to be able to turn it on/off put it on a line after the field with an indicator 45 DSPATR(PC) when 45 [...]

View Answer   |  July 27, 2010  11:35 AM
AS/400, Cursor operation, DSPF, RPG, RPGLE

sql 2008 export to txt for backup and incremental backup
You’ll want to use the BACKUP DATABASE command to backup the database to a .BAK file. You can them backup this file up to tape as needed. You can use the SQL Agent to create a job to backup the database every day. If you need point in time recovery you’ll need to also schedule [...]

View Answer   |  July 23, 2010  7:39 PM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database

Access VBA Code stops at Midnight
Do you have any scheduled tasks or a backup job that starts at that time? Does it disable access? When do they become available again? How are the scripts running? If they are running as a user is that user automatically logged off at midnight?

View Answer   |  July 23, 2010  5:16 PM
Microsoft Access, VBA

Access form to link to Google Maps
I would get help from Google for this one

View Answer   |  July 23, 2010  3:26 PM
Access, Access 2007, Access 2007 form creation, Access 2007 functions, Access Database, Access Database Design

exchange 2007 email forwarding exception
Yes, in Outlook, when you set up a rule you can also include exceptions to the rule. Modify the rule to have an exception “Except when email is sent from” and then put in the HR department email address.

View Answer   |  July 22, 2010  6:21 PM
EXCEPTION statement, Exchange, Exchange 2007, Exchange 2007 Email Delivery, Exchange Forwarding, SBS 2008, Windows Small Business Server