Search results

Interesting...I was cleaning up my DB and deleted some unused Tables, Forms, and Queries, and it seemed to have fixed my problems...

I'm not sure how well that will work since all the data is remote in a SQL database, but I can if you want me to.

Yes. With the same results. Also, the last attachment in my previous post shows the query, and how the results should be displayed.

Attached are some screenshots. Let me know if you need any more.

It's named "custref"

I have a form pulling from a query with a number of fields. All the fields display the information properly, except the "CustomerRef_FullName" field, which shows up as "#Name". The field displays properly in the query, but not the form. I have the query field as the control source for the text...

OK so now that I have the proper items selected, I would like it to give me a SUM of those items with "SHIPPED" in the location field of the "Time Table". Any way to do this?

Got it now. 2 Queries: one query with Order Number, Start Time, and Part Number, with MAX on Start Time, and the rest in the other query.

Well what am I doing wrong? I tried to set it up like that and still getting multiple entries: SELECT Max([Time Table].[Start Time]) AS [MaxOfStart Time], [Time Table].[Order Number], dbo_salesordera.IsFullyInvoiced, [Time Table].[Part Number], dbo_salesorderlinedetail.ItemRef_FullName...

I see that thread, but can't seem to make it work in my scenario...

I have a database full of Time Entries, linked to other tables, to show all information in one location. The "Time Table" stores the "Part Number", which is linked to "ItemRef_FullName" in the other table. When I enter an Order Number, I want it to return a list of parts, with only the latest...

I found out what causes the problem: it is my criteria: (dbo_invoicelinedetail.ItemRef_FullName)=[dbo_salesorderlinedetail.ItemRef_FullName]) This is what I use to select the specific matching record. If I remove this, I see all tied records from the Invoice. But it appears this is what is...

Anyone? HEEELLPP!!:confused:

Use criteria on a potentially null field? OK. So I have the following query: SELECT dbo_salesordera.RefNumber, dbo_salesorderlinedetail.ItemRef_FullName, Sum(dbo_invoicelinedetail.Quantity) AS SumOfQuantity, dbo_salesorderlinedetail.Quantity, dbo_invoicelinedetail.ItemRef_FullName...

Whenever I run the following criteria on my ODBC SQL connection, Access closes with the error "Access has stopped working". If I run the same query on a local database, it works fine. If I run the full query without that criteria on my ODBC connection, it works fine as well. Only with this code...

I think I may have been going about this the wrong way, so I'll see what you all think would be best. I need to make a system that tracks the time required to make a part, as well as a way to check the current status/location in our warehouse. Additionally, it needs to be an easy to use...

What the query is designed to do, is first group the results by order number, then part number. It takes that grouping, and looks for the "SHIPPED" location in a line item for one of the entries. Once a "SHIPPED" line item has been added for each part on an order, the order disappears.

Bump----^----

What do you call a paraplegic in the water? Bob.

We have a query that we use to hide completed orders, when all parts in an order are finished, and have a shipped line item. The code is as follows and is added to the criteria for the Order Number column: In (SELECT DISTINCT [Order Number] FROM [Time Table] AS Q1 WHERE exists (SELECT DISTINCT...