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
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
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
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
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
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
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
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
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
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
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
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
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
<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
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
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
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
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
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
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