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
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
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
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...
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...
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...
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...
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.
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...
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...
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...
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?
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)...
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...
This is a possibility. OPC is supposed to be a standard method of transmitting process data. If there is good documentation available with their OPC server then you have a shot. I have some limited documentation on OPC server standards. However, I am just getting started in it myself. So...
The ideal form of a consulting project is a partnership. If you are the service provider your pay should be based on the profit generated. This only works if your "client" is willing to provide the needed resources. In theory, this applies to an external consultant as well as the...
