Search results for query: *

Hello, I'm hoping someone can help me with the following. I've searched both online and this forum and can't find an answer or have missed it somehow. I have a vbscript that connects to an Access db on a file server and writes data to a table. Everything works fine until we lose our network...

RiverGuy and Djangman, Thanks for your replies!

Hello, My question concerns what I'm trying to do more than how to do it. I'm using VB.Net for a Windows app that will perform a series of calculations based on user input. Rather than displaying the calculation results in the form, I'd like them displayed in a report that can be printed. I...

Hi CaptainD, Sorry, I haven't checked the forum much today. I'm not sure I understand your question; What are you using to keep the "Lengths" and "Circumferences" together? I think the answer would be the test code. Every test has a unique code. As far as a primary key, the data table contains...

r937, That's pretty awesome. I appreciate all your time and effort. I would like to see the results of the aggregate functions returned also. But I'd like to attempt modifying what you've given me on my own. If you'd like to post your solution to this, I'll try not to "peek" until I've given...

Ok, hopefully this will help. This is the test code table. TestCode TestDesc UOM Comments 201 LZ CIRC MM 203 LENGTH MM 205 WEIGHT GT G 10 unit weight 211 WIDTH MM 214 THICKNESS MM 415 WEIGHT G Single unit weight This is a sample of the test...

r937, Sorry, I misinterpreted your earlier post. The column in the TestData table actually contains a test code (i.e. - 203 for LENGTH). That's why I have the inner join; to allow the user to select a test name rather than a code. Also, the "%" did not work, either. Thanks anyway! CaptainD...

Yes, I'll try. The data table (TestData) stores raw data on different size and shape parts. The parts are given a lot or batch number, Dnumber. So a given Dnumber may be for cylindrical parts for which the part LENGTH, circumference (LZ CIRC) and maybe even individual part weight (WT) are...

Thanks for all your replies. First of all, for my benefit and knowledge, can you explain the use of the "*" in the HAVING clause. Is it supposed to be a wildcard character? Second, I still could not get the AND version to return any records. I've also double checked the data table and there...

Thanks for your response. I tried your suggestions in the query window. The OR version worked as I thought. It returned every record that had at least one of the test types within the search ranges. The AND version, which I had hopes for, returned no records. I tried regrouping the HAVING...

Hello to all, I'm working with SQL in Access VBA code behind a form. And I'm not an expert in SQL or Access, so please bear with me. I have a query that gives me an ID (Dnumber), a test type (TestDesc) and several aggregate functions based on raw data stored in a table. The query (from the...