Search results

Its in Query1

Please see the attachment, I think its better describe.

OrderID, OrderDate, ProductID, OrderQty,ProductionDate, Production Code ProductionQty 20 8/18/2014 236 1000 08/18/2014 236 100 21 8/17/2014 236 2000 - - if there is no production its display 0 and is there any...

Alright the actual value. Order Date, ProductID, OrderQty, ProductionDate, ProductionQty

Order ID, Order Date, Product ID, BegInventory, OrderQty, ProductionQty, Ending Inventory((begInvetory+ProductionQty)-(orderQty))

Here is my attachment, what I want is query 1, only show one Production data, if there is an order for that product or not

Here is the relation, will you please let me know, I still have same issue

I do not want to show all the dates, only those date which has order. I will work it out and let you know.

Here you in plain English but its my second language. we have a Excel Spread Sheet, where in Row 1 has dates from January 1 to December 31, Column A has product code, any order we received we enter in the date where is the product. the problem with the Excel sheet many time the user (which are...

How I am gonna link

In the crosstab query, there is only one record in tblProduction, ProductionID 9 ProductionDate 08/18/2014 ProductionCode 236 ProductionQty 50 In the query its showing in all the product, I want only to show once in the product 236

They both are texts, please check. ProductID is text in tblProduct ProductionCode is text in tblProduction.

Hi guys, need little help, please see the attached MS access database, what I am trying is to make a database, based on our production schedule, we add orders on daily basis and plant scheduler check the order status and ending inventory, and schedule the product. if you check the attached...

Syntax Error Crosstab Query with Criteria I have a following code in crosstab query to bring the result between range of date, will anyone help me out to solve this issue, the only thing I want to give criteria (range of date) to crosstab query PARAMETERS [Start Date] DateTime, [End Date]...

Guys need help here:confused:

any thoughts?

The hand written sheet is the data we collect on the production floor, one sheet represent the table number, and each table has 12 employees. we weigh manually each container and write down the total lbs. there are different product produce during the day. Due to the error in data enter in...

Not yet will you please explain me little more.

Forget to insert images

Guys banging my head to wall :banghead: is not solving my issue. There are 2 images I am inserting, I want on the Access form to display the total of row (each row is batch number) in the box after pressing the button in the form. based on Product code, date and table numbers.