Recent content by everest

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

Hi, I'm writing a report with a number of figures. I've inserted captions for each figure but the numbering seems to be screwed up. The numbers jump in multiples of 3. For 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...

Thanks for your help Mike. That did the trick.

Thanks for your reply Mike, I tried to simply my example, but I guess it backfired on me. Totally my fault for leaving out important information. I actually calculate the percent field in the current table. I'm not sure how to use the IIF function with a calculation. Here's a little more...

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