Search results

Pat, You're awesome! Transposing in excell worked (with a few iterations due to the size of the table). Thank you!

Is there a way to normalize the tables and keep the data intact? The point here is to normalize the tables and get the data into a normalized form. If there is a good way to do this I'd love to hear it. Looking over some threads about normalizing data, it looks as if this is non-trivial and can...

Just giving this a little bump. I'm very much hoping that there is a more clever way to do this.

Thanks Keith. I was hoping to avoid this since there are 60+ materials but, looks like this is the only way.

Ok, I can't get meloncolly's suggestion to work. Possibly because the analysis results are cells in the table columns (each column is a different material) and I don't know how to just return the name of the column in one cell and the result of the column in another all in the same row. Can...

Neil, Thanks for the comment. I know this isn't normalized. The purpose of this query is to get the data into a normalized form and so it can be loaded into a normalized system. Meloncolly, I'm not sure I understand what you're suggesting. Are you saying that I should create a union between...

I have a table which stores multiple materials in different columns, and the analysis results for each material in the associated cell. I need to create a query which will display a new row for each material and result with all the appropriate associations (location, date, time, etc.) Is there...

Thanks very much! Found just what I needed on this thread http://www.access-programmers.co.uk/forums/showthread.php?t=74847&highlight=BeforeUpdate+event+save . Looks like you've done quite a bit of work on this. Much appreciated.

I have a form with several sections which corrrespond with different tables. Currently, when a user clicks or tab's through to the next section, the previous section is automatically saved into the corresponding table. Is there any way to over-ride this automatic saving and have the form be...

The database stores a [results] numeric field and an associated [sigfigs] numeric field. I need to combine the two in a query like so: If number of characters in result < value of sigfig, find n= [sigfig] - [number of characters in result], CStr[result] and add n number of 0's to end of result...

Matt, Thanks for the response. This works but, it also counts the decimal point. Is there any way to either exclude the decimal point or subtract 1 if there is a decimal present?

Does anyone know the syntax to count the number of characters in a numeric field? If not, how about counting the number of characters in a string?

Personally, I'm not a fan of mediawiki (the one used by the wikipedia). The biggest advantage to MediaWiki is that the syntax is widely recoginized (wiki Syntax is not standard and varies for most wiki engines) as is the format/overall user experience. However, if you need to modify anything in...

I also searched both for an access wiki and a database design wiki and found neither. Although, there are plenty of brief notes in some wiki's or individual blogs, I haven't found anything dedicated or very extensive. So, unless I hear otherwise, or someone points me to a good wiki for this (I'd...

This thread looks like it could benefit from the wiki format rather than a forum. As I've benefited much from this thread, I'd be happy to put up a wiki for it so the tutorial can be edited and discussed collaboratively as needed (I'll even splurge on the $15 to register a domain). Let me know...

Excellent!! Does just what it should. Many Thanks.

Ahh, sorry. It's in a Control Source.

The Formula is in a report which is generated from a cross-tab query. In the report I currently have all of the fields I need but, want to check if there exists a grab or integrated record without displaying the record, just display some mark that there is one.

Thanks for the response Paul. That didn't generate any Syntax errors. The report ran mostly as expected but, all of the check boxes are empty, even the ones associated with [SampleTypeCode]="Grab" Or [SampleTypeCode]="Integrated" (I kept this field displayed on the report for now). Not sure...

Thanks for the response Paul. That didn't generate any Syntax errors. The report ran mostly as expected but, all of the check boxes are empty, even the ones associated with [SampleTypeCode]="Grab" Or [SampleTypeCode]="Integrated" (I kept this field displayed on the report for now). Not sure...