I have this excel file that needs to be formatted for some old fortran program. In excel, it looks something like this:
Site Atim Zo VS
----- ----- ----- ------
Main St. 60.00 0.00 0.00
1st St. 20.00 0.00 0.00
Washington 80.00 10.00 10.00
The...
Hi,
I'm pretty new to VBA and I've got this problem with some data I'd like to format.
The data is formatted like this:
Date Time Value
2/10/04 22:00 25
2/10/04 23:00 26
2/11/04 00:00 27
2/11/04 1:00 28
2/11/04 2:00 29
....
2/15/04 1:00 30
2/15/04 2:00 31
The data continues for several more...
...example, I have a Figure 2, then it goes to Figure 5, then Figure 8, etc. The field codes for the captions are all the same. It's {SEQ Figure \* ARABIC }. Maybe there's something wrong with my field code? Or it could be some bug in Word 97? Has anyone ever run across this and know of any...
...B-2 Iron 10
B-2 Lead 10
Table 2
Element Total2
Iron 6
Copper 2
Calculate Percent field using LEFT JOIN and(Total2/Total)*100 AS Percent ON Table1.Element=Table2.Element
Joins into Query 3
Query 3
Site Element Percent
A-1 Iron 60%
A-1 Copper...
Hi,
I have query that join two tables together.
Table 1
Site Element
A-1 Iron
A-1 Copper
A-1 Zinc
B-2 Iron
B-2 Lead
Table 2
Element Percent
Iron 60%
Copper 20%
Joins into Query 3
Query 3
Site Element Percent
A-1 Iron 60%
A-1 Copper...
The data in the transposed table needs to be unique/individual data points. To get around this, I just checked (counted) to make sure that each date has only one instance of a chemical/element. Then I just use a max,min, or average. Should return only one value for that field.
I used the...
Hi,
I have an excel question regarding sorting individual columns.
I have data in such a format
Iron Lead Zinc
0.5 0.3
0.2 0.1
0.2 0.1 0.2
And I would like it to be in this format
Iron Lead Zinc...
Hi,
I have a question about querying environmental data so that it is transposed (sort of).
I have an Access table with three fields, Element/Chemical, Date, and Result.
For example, I have:
Element Date Result
------- -------- ---------
Iron 2/1/03 10...
Skip and Ken,
Thanks for your help. I have been running the comparison using Skip's method before I posted the question. I would make a criteria for each pollutant and then modify the previous Dcount formula. It was just getting to be very repetitive manually entering in a criteria for each...
I may have asked this question before but I can't seem to find the past post.
I have some water quality data to compare against government standards. Out of a dataset, I need to get a percentage of how many datapoints exceed the standard. Right now, I'm doing this with the Excel function...
I put together an external harddrive using a Coolmax enclosure and a Maxtor 120GB drive. It was working fine before, but now the transfer rate has gone down significantly and sometimes freezes or stops in the middle of transferring large files. I'm just wondering if anyone has run across a...
That works. Thanks. I actually saved it as a .CSV file and that got rid of the single quotes. Just did a cut and paste back into the .XLS file. Thanks again for your help.
I tend to leave out some important details in my posts.
In the time field for the Excel file, there are some fields that don't have single quotes in front of them. I'm thinking that Access doesn't know what to do when it sees some with quotes and some without. It just sends these fields to...
Hi,
I asked a question a few weeks/days ago about removing single quotes. I've tried the advice given to me but with no success.
I've imported a spreadsheet from Access to Excel. In the Excel spreadsheet, there are single quotes at the beginning of every cell. At the time, the single...
I'm guessing that data type means the format of the cells? I have all of the cells formatted to General. This single quote appears. Please correct me if I'm wrong.
After playing around with it, excel seems to ignore these single quotes when performing calculations which was my biggest...
Hi,
I have a project that requires me to compare bunch of water chemistry data with certain limits. I might have 10s or 100s of data points for a certain chemical and I need to get a percentage of data points that exceed the limits.
For example, I might have five data points for mercury that...
Well, I'm using Access 2000, and on the screen/window that lists all the tables you have in the database, I right click on the table that I want exported to Excel97 and I click on "export". Then I just save it as an excel file. I hope this is detailed enough. Any help would be...
Hi,
I have a spreadsheet that I've imported from Access to Excel97. In the excel spreadsheet, I keep getting these single quotes in every cell. I've tried running a replace to delete these single quotes, but it doesn't work. Does anyone know of a way to get rid of these single quotes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.