Search results

OK. Just tried the localized version and it works, but the SQL one does not...

Here you are. Typically runs off a SQL server, but made a localized copy for you. Also converted to MDB for your convenience :D

So, if this is my complete query: SELECT [Time Table].[Order Number], * FROM ([Time Table] INNER JOIN dbo_salesordera ON [Time Table].[Order Number] = dbo_salesordera.RefNumber) INNER JOIN dbo_salesorderlinedetail ON dbo_salesordera.TxnID = dbo_salesorderlinedetail.IDKEY WHERE ((([Time...

OK. I've managed to tie the tables successfully and get the data I need by linking the three tables. Now, when I try to run my criteria to filter out closed orders Access "stops working" and closes. Here is my criteria: In (SELECT DISTINCT [Order Number] FROM [Time Table] AS Q1 WHERE exists...

I am trying to put together an advanced query, but can't figure out how. I need to pull data from 3 tables. Table A has Order Number and Part Number as entered by user. Table B has order information (eg. Company Name) Table C has the part information for each order line item I need to build a...

Thanks a bunch!

I need to make a button in a subform that tells the parent form to go to a new record. Any ideas?

By George, I think you've done it!! Many, many, many thanks! Now a quick n' easy one. What query would I run if I wanted to see orders modified 1)today and 2)this week, regardless of status?

Precisely.

Perhaps it would help if you had a useable copy of the database. I've attached a coverted local edition to an MDB for your viewing pleasure ;)

That doesn't seem to remove anything... It just shows all orders. Here is an sample of an order: So as you see, this is all one order. One location line of one part in one order is SHIPPED. What needs to happen is if a location of shipped is added to all three parts that it is hidden.

OK. That just gives blank results...

Wow. Very nice. One caveat. One order may have several parts. We need it to display all entries for an order until each part in the order has a "SHIPPED" entry. Your SQL command hides the order if ANY entry displays "SHIPPED" is this even possible?

OK, so I'll try to explain this the best I can. I have a table (Time Table) with the fields ID, EmpID, Part Number, Order Number, Start and Finish Time, EmpName, Location, and Quantity. I've developed a database that has a multi-item form showing all of the non-finished orders. These orders...