Search results

I am wanting to print a single label after entering in an inventory item by clicking a command button. What I end up getting is the whole database (which is now more than 1,000 records). How do I narrow that down to the latest / current entry?

Not sure if I'm in the right area but here goes... I have two tables [Transaction Types] and [Inventory Transactions], that are linked through [Inventory Transactions Extended query]. When I print a "Load / Shipper" report based on the [Inventory Transactions Extended].[Shipper ID], I'd...

I have a query built and the original calculation field for a net sale was based on [weight]*[bid] - and it worked (in bold below), but now I need to be able to have an if statement so that my net sale column is calculated based on either weight or quantity, depended on wether or not the line...

I have the following code in an extended query that feeds into a form. The calculated fields show up in the query and on the form, but when I go to create an invoice report... nothing shows up. I have the same problem for my Tare Weight and Net Sale fields ... I'm sure once I figure one out...

Please see the attached document first. I am trying to create a main query that I can then use to export all of this data into Pre-created Word documents. I have tried several ways to create the query, changed relationships, etc., but I either get 1/2 of the data at a time (Top or bottom...

I am creating an inventory / shipping database system for a local non-profit. I have it almost done, but when I select the vendor to ship to (via a combo box), all products (regardless of time) of that type are changed to the vendor selected. I need to be able to have multiple vendors for...

I'm new to Access and wanting to create a shopping cart like function of inventory items that an end user can then pre-screen and check off the actual items to go forward to a new form/query to be assigned a bid control number and then be exported to excel for further processing internally. I...