Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rush

  1. rush

    Querying database in Excel

    Another alternative for summary data if the data is already in an Excel spreadsheet is to use the sumif function. Sometimes you can accomplish a query by parameter using this function. Bill
  2. rush

    help with grouping by dates

    Any additional function slows things down. The additional time usually isn't noticable, however. In your case is isn't that large of a table. So it should not be significant. The only way to know for sure is to try it. Bill
    • rush
    • Post #9
    • Forum: SQL
  3. rush

    Querying database in Excel

    You can summarize the tables by running a query on the table with the data. Then display the results of the query on another sheet. You can do this with VBA also. Bill
  4. rush

    MAKING ACCESS CENTRALIZED

    You can also use Access to supply data to a web page. This allows several users to access the same central database. As mentioned above the number of users and number of times then request data may indicate a database designed for more users. Access will work for a limited number of users at...
    • rush
    • Post #3
    • Forum: SQL
  5. rush

    help with grouping by dates

    Sorry, I read the earlier post and replied to it by mistake. To group by date ranges might be possible but my first thought is that it would be messy and get quite large. Some systems have a limit on the size of the query string. Adding a field that contains the Fiscal Month in the table...
    • rush
    • Post #7
    • Forum: SQL
  6. rush

    linking a field in one table to a recordset in another table????

    Can you explain in more detail what you want to accomplish by "linking" fields in one table to another. I think if we knew what you were trying to accomplish it would be easier to suggest something. Linking fields can be done many ways for many purposes. Describe the fields in the...
    • rush
    • Post #3
    • Forum: SQL
  7. rush

    help with grouping by dates

    You can Group by the Datepart function on each month instead of using it to 'Order By' and Order by Date. That should work for you.
    • rush
    • Post #5
    • Forum: SQL
  8. rush

    VC++ vs VB vc C#

    I know you don't consider VB a "real" language, however, it does have it's advantages. It is in use by many companies for several reasons. In the dot net environment, VB.Net runs on the same engine as C# so the differences are in the development. Everything I have seen about...
  9. rush

    Launching Application via VB6 program

    Have you tried the shell command? It will run an external program in a separate window. If you need to wait for the external program to finish first before you do something else it becomes more complex.
  10. rush

    What is Programming language engineering?

    You can call yourself anything you want. However, it is being able to do what the customer wants that is key if you are going to "sell" your services. Try looking up Software engineering. WWW.SEI.CMU.EDU is a site that explains software engineering. It deals with looking at...
  11. rush

    Access 97 Indexing problem

    Not sure. I haven't had this happen. It could be a corrupt database. Try the repair function and see if it still happens. Are you compacting the database periodically? This should be done on a regular basis. As well as backups...
  12. rush

    Microsoft Quick Basic to Visual Basic conversion

    I teach VB6 and I agree with the last three posts. You will in reality only be able to convert some functions and subroutines. The logic flow and event driven code are quite differnt. The enviroment is also much different. The learning curve may be a bit frustrating in the beginning going...
  13. rush

    Two Tables

    Can you give a little more detail. Do the two tables have the same types of fields? Do you want both fields to be 'unmatched' or either one? Any indexes on the fields in each table?
    • rush
    • Post #3
    • Forum: SQL
  14. rush

    help with grouping by dates

    If you want to group the results by each month starting at Jan, try: Order by DATEPART("Mm", {Datefield} ) ==== The SQL Server DATEPART() function returns a portion of a SQL Server datetime field. The syntax of the SQL Server DATEPART() function is: DATEPART(portion, datetime)...
    • rush
    • Post #3
    • Forum: SQL
  15. rush

    Vacuum pump performance

    There are a lot of factors to consider before offering any suggestions. The typical vacuum/pressure range, normal RGA analysis, piping size and components, layout of valves and testing ports, diagnostic equipment available, etc. If you can post this info here, some general suggestions on a...
See more

Part and Inventory Search

Back
Top