Search results for query: *

Appreciate the advice. I will indeed check out this and other versions of SQL. Thanks again.

This is the way i will proceed then. I will have to investigate the SQL versions though. I want to keep this as simple as possible. A small SQL server footprint is what i want. Have you had any experience with MySQL as a server. I have SQL2000 Installed now on my machine. Guess i will try both...

What would you recommend? I am still in the design phase as far as storing this data, so i am open to suggestion on how to handle it.

The data is for network performance monitoring so i need every single hour available. Of course a date-time stamp would be in each record to seperate them. All 70 tables together amount to about 2.5megs while in Access per hour. I was concerned this might pose a problem with the db growing too...

I have a data source which outputs about 70 Tables worth of unique data hourly. I am working on a front-end that will allow access to this data. I want to be able to view the data in hourly increments as well as 24 hour, Monthly, Quarterly, and Semi-Annual increments. My question is... What...

Can the column header of a listbox be colorized? Thanks, Brian

Thank you BlackKnight. I was fiddling with this all night and came to the conclusion that for some reason, the LEFT Join is causing the problem. I tried the mod to the SQL you included above but i still get the #Error. I then took a new approach to the problem. I split the source into 2 seperate...

Here is the query by itself: Expr1: IIf(IsNull([Avg Serving RSSI 1]),0,[Avg Serving RSSI 1]) Brian

Here is the SQL from the query in question: SELECT Adjacencies2.Serving, Adjacencies2.Target, [Avg Serving RSSI 01].[Avg Serving RSSI 1] FROM Adjacencies2 LEFT JOIN [Avg Serving RSSI 01] ON (Adjacencies2.Target = [Avg Serving RSSI 01].[Target 1]) AND (Adjacencies2.Serving = [Avg Serving RSSI...

I have a query where the source table occasionally has missing data. This is normal. The query returns #Error where the data would normally be if it were present in the source. I have tried using the IIF function to force the #Error to a value of "0" with no luck. No matter what i do...

I have some vb code (included below) that formats a text file into a flat text file of data with a row-space between each data-group. I want to be able to take each data-group and save it as an Excel Worksheet within the same workbook or save it as an Access table within the same Database. The...

This can be done without the use of an aspect script. Capture the OM to a device, say on an hourly period (Busy Hr) or whatever you like. Build a spreadsheet to handle the OM Groups you want graphed. All you have to do is copy and paste the captured data. I have just a thing that i use for my...

Thanks Skip. I will put it to good use. Thank you very much. Waxaholic

One more thing. A typical non-formatted file (raw text) is 42000 lines in length. A formatted file (parsed) line is 6200 lines in length. Broken out into separate sheets would make it even more manageable. This would allow me to even append future data to each table. Maybe. :) Thanks, Waxaholic

Disregard the multi-line statement. I know that might have been confusing. Perhaps my term of parsing was used incorrectly. The data example above was the result of the existing code formatting it into single line data. I want to include code in my existing code to break each group (SS001...

I have a multi-line text file i am parsing into single-line. I want to be able to separate specific ranges of data within the file and save them to Excel sheets bearing the data groups name. An example of the data is: SS001 KEY DLA DLT 1 1 22 356 2 2 38 59 SS002 KEY SLM MLT 1...

Works like a charm. Thanks a bunch. Brian

Thank you. I will give that a shot. Thanks, Brian

I am getting a #Error result of an Access SQL statement. Is there some code i can use to default to a specific value, say "0", when this happens? Something to wrap the SQL in when this divide by zero error occurs and output the value "0" to the cell. Thanks, Brian

I created a drill-down in Access using a combobox and 2 listboxes. The combo would generate a listing in listbox1 and a doubleclick on an item in listbox1 would generate more info in listbox2. Now i am trying to learn how to do this very same thing in VB6 but am totally lost. I created a DED...