Recent content by czarjosh

00000000002207",= Report_ID "MA01013308", = Value 1, = Field_Number "CERT1a", = Field_ID "Facility ID" = Report_Label The example that i ahve post is one set of this data. In teh big text file it is the excel report that you see (only CSV) but lumps them all together, so the next report...

Unique Values: Report_ID = 1713 Field_Number = 1309 Field_ID = 1309 Field_Label = 167 Value = 303279 One problem is that Field_ID and Field Label are related. for every Field_ID there is value (or it may be null). But many Field_Labels are duplicated. Thus meaning one field ID can have many...

The field name is "Home Address" or whatever. SO when I make a query iw ant it to list teh value i select in one column AND in teh second column i want it to display the label of the field name.

that does not bring in teh name of the field

would it enlighten the probelm at all if you knew that I also have a copy of this file in vssscc file format. ANother Option, I also have each 'data set' broken apart into individual excel spreadsheets.

How do I display the field name as a value in my query?

i would liek to transform it into that for sure. The rease i have the skip portion is, that literally, that is how many rows og information are skipped before the data set starts over, there is just countless bit of inmformation to be looked. I am doing a regular improt from a text file in the...

I am posting the data the way it exists in the text file now. I am nout sure about the crosstab option, i have never done that before. I do nto know what the TRANSFORM is. Data as it exist in the text file: "00000000002207","MA01013308",1,"CERT1a","Facility ID"...

here is an example of the data after it gets put into the table Report_ID Field_Number Field_ID Field_Label Value 00000000002207 1 CERT1a Facility ID MA01013308 00000000002207 2 CERT1b Test (T or F) .F. ****skip 1523 rows **** 00000000002207 1308 MA583b Administrator's telephone number...

it is comma deliminated, and there is a patterrn to it. I know the first and last field of every data set.

i have figured out how to convert the 167 unique values in teh 5th field into field names in a seperate table. Now comes the bigger problem. My data is all lumped into one bit file. Basically the file 5 fields. They are report_ID, Field_number, Field_ID, Field_Label, Value. How do I begin...

i was given a very big txt file, that when i put into access is a complete mess. Though there are about 300000 records, i have identified in one of the field 163 unique values. I assume these are field names. I was wondering how i can make a table otu of these 163 unique values, so that i...

Well her eis an example It is grouped based on COmpany then in the details section, it has the county Breakdown. IE joshferris.com Total - $15 Allegheny $5 Butler $10 So how do i story this sum in a seperate recordset.

In my group header I have a Sum field where it sums all of the Money data in the details isection. How do I sort by this field. I want the report to display from highest value to lowest value, however in sorting and grouping box, it only allows me to choose from fields in in the query the...

this is an example of the query before I add the totals rows: WD PR ContactData 22 1 Bad Contact 22 1 Bad Contact 22 1 Bad Contact 22 1 Bad Contact 22 1 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 24 6 Bad Contact 5 2 Bad...