Search results

If in the query you are only pulling it for plant 6002 then yes.. But the query should look for matching data..... base on a matching 711 and 712 entry which will offset one another based on like data fields... NSN, Qty, Plant.... This will tell you that the item (NSN) was pickup as a gain...

I attached a file of what I get when I do just a basic query... the data displayed is what I dont want to appear in the query....

Yes, perfect.... So to do that, would I have to create a new table? Also, can I use a basic query to do that with additional statements in the design view fields?

Offset indicates that there is a matching 711(loss) entry to a 712(gain) entry and cancel's each other out.. If the entry dosent have a entry that offsets the other, it should be displayed.. This report pre-determine in the ERP, it is self generated when selected, should I break the table up...

I have been working with Access allot in the past few months, I am still trying to figure out allot of the basic stuff. My last four posting related to anther database I was working on, but seemed to complicated to start out with, so I decided to take it step by step... The database is based...

I am very new to access, could someone help me setup a query that does the following: 1) Using the SSF table: I need a query that will match up Plant, Routing Identifier, NSN and Qty to determine a true match based on a Movement Type 711 / 712 which means the data offsets each other and should...

Thanks RainLover, I was looking at your InventoryControl example database and it's a little similar to what I am trying to do, would you mind looking over my database and giving me you opponent on improvements that I should make? I am very new at this and plan on taking programming class next...

I have duplicate data in a cell, I want to hide duplicate data and display only non-duplicate data.. I changed the property sheet to only show unique values, but it keeps showing data I don't want to see... can anyone provide any insight into this issue... Thanks

I have data that matches in 3 different cells, I want the data that dosent match to display... I changed the property sheet to only show unique values, but it keeps showing data I dont want to see... can anyone provide any insight into this issue... Thanks