Search results

How would I do that?

Thank you for everyone's input in getting me to the end result, if you have suggestions on how to clean up or improve the query I'm happy to hear your ideas. Thanks again :)

So, I've found a workaround, its not elegant but it works (for now). SELECT part_Catalog.PartNbr, part_Catalog.Description, part_Catalog.NSN, part_UICodes.Code AS UI, part_ShelfLifeCodes.Code AS SLC, stock_Locations.Location, part_Catalog.QtyAuthorized AS TAQ, stock_StockDetail.Qty AS [POS...

Appears to be text with a field size of 10. Not sure why they made it 10 when its always a one digit character. The other codes run from 0 thru 9 and A thru Z.

The error message is back, I tried with and without the '' around 0 in part_ShelfLifeCodes.Code

No longer getting the error message, but its returning no results which I know to be incorrect. I've been looking at the data and it appears part_ShelfLifeCodes.Code is padded out with a bunch of spaces, not sure if that makes a difference.

Windows Server 2008 R2

I'm getting this pesky error message:

Thank you but honestly I don't know how to implement the above, here's the current SQL: SELECT part_Catalog.PartNbr, part_ShelfLifeCodes.Code AS SLC, stock_Locations.Location, part_CatalogStatusCodes.Description AS Status, Mid([stock_locations].[Location],9,2) AS LOCATDetail...

At the moment its pulling anything that is falling between 07 and 21 in the LOCATDetail field. I want it to just show results other than 0 that are outside 5A002A thru 5A002G with LOCATDetails 07 and 21. I'm thinking you meant Stock_Locations.Locations whilst I agree with you, the field is free...

Need some assistance please, trying to write a query to filter data against several fields. Field 1 is called 'SLC' and I want to find all records that aren't '0'. Field 2 is called 'Location' and I want it to only look for the above records outside of 5A002A, 5A002B, 5A002C, 5A002D, 5A002E...

SELECT [SPOL01 Shelf Life Batches].PartNbr, [SPOL01 Shelf Life Batches].Batch AS [SPOL Batch], [SPOL01 Shelf Life Batches].[Batch Qty] AS [SPOL Batch Qty], [SPOL01 Shelf Life Batches].ExpirationDate AS [SPOL Exp Date], [POS Shelf Life Batches].BatchLot AS [POS Batch], [POS Shelf Life...

Thank you for tips, I've managed to get the query to work as expected.

Good Afternoon. I need some assistance please. I have two tables (SPOL and POSSL) containing shelf-life expiration dates for various products. The dates are stored in a field named ExpDate and both have a common field of PartNbr to match against. I need the query to compare the dates between the...

Thank you. I can't see any design details for the Child0 subform, I was hoping to replicate this process with other similar data. I imported the subform Child0 into my form and tried linking on ID and CatalogID however I received the attached error. I can't see / don't understand what I'm doing...

Oh wow, that’s totally my mistake, sorry. I’d been working on reports all week and had them on the mind. I’m this scenario/requirement it’s a subform.

Thank you, I've tried applying this to a Form, however having problems with the data fields showing an error. What am I doing wrong?

Hello all. I'm trying to create a subreport linked by field [CatalogID] from a crosstab query. The columns of the query are dynamic and I'm struggling to get the subreport to function correctly when the data changes in field [Year]. I've attached screenshots of the crosstab query and of the data...

Thank you!

Hi all. I'm trying to categorize order data and compare rush orders against previous order history. I've created two queries 'Rush' and 'Orders' to gather only the orders I'm interested in. What I'd like to do now is categorize each line in the 'Rush' query to determine if the ordered part has...