orders

Hello I have three formulas that calculate three different numbers in the format: "23 USA orders", "53 EU orders", "36 ASIA orders". How can I return the first biggest and second biggest from the above? Thanks!

:rofl: Hi, Please could someone help i'm after counting unique orders numbers across several sheets, i just need a total unique numbers in 1 cell on another sheet Thanks,

Hello can suggest me how would be a good way to allocate stocks to orders, and know, how much and what type of stock was assigned to each line row of the order Example Orders table <tbody> N_Order N_Item Qty_Asked 20001 10000001 100 20001 10000002 200 20002 10000001 50 20003 10000002...

I'm trying to create a production schedule that is 24/7 that will show an overview of what is currently running and when it'll be done. I was able to make macros (which i've never done before) so the code is horrible, I'm sure, but it works for the most part. Essentially, on the Open Orders...

I have a spreadsheet with sales tax collection data for 2018's Q4. It includes which county specifically each order's sales tax was collected for. See below: I need to calculate the total sales tax collected per county in orders shipped to California in column M. To accomplish that, I’d need...

Hello, I have a large list of orders and would like to condense it down to only the orders I am sending. This needs to be down on a weekly basis, so the rows will not always be the same number. I thought using a user form to select and delete the rows specified would be the easiest way, but I...

Hi All, I work in a hotel and I am trying to create a simple tracking worksheet that will keep track of work orders that we give to our engineering department to get things fixed in the hotel. I know that this would probably be easier to do in access, but given the staff that this will be...

I'm trying to create a list of all the oldest orders my customer has. but I can't seem to get my subquery to list one record for each CustomerID. Whenever I add the Order Amount to the subquery every orders lists. I have these tables tblCustomers - Customer ID, Customer Name, etc...

Evening. I trade currencies on the foreign exchange and want to create an automated way of creating 'scripts' that i can use to place orders. I will have a different number of orders over a different range size and i would like to create something that will show me where the orders should be...

I have a set of historic order data going back for several years. Simply structured like so: <tbody> A B C D Order number Customer Order Date Delivery Date 12345 Customer A 20/12/2017 06/01/2018 54321 Customer B 01/01/2018 10/01/2018 </tbody> What I would like is to show is how many...

I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...

Hi guys, I am having a little bit of trouble getting my DoCmd to execute properly. I am quite new to running code thru event procedures so I'll do my best to explain. I am needing a query to run and then requery and then email that query to a known email address. Below is what I have come...

Hello all, I am hoping someone can help me. I am looking for a way to highlight any orders that are put in to a sheet that take the requirement over the current stock, But only highlight those orders not the ones there is enough stock for. So in the example below Alice's order of code 123 would...

Hi all, i need to create a formula as per the below where you have a store with customer orders in column A, what is in stock in B, what they have soon to arrive at store in C and D is how many they are short. Column F is what stock is in the warehouse, and waiting to be transferred but due to...

Hi all, I need some help with a formula that can count how many orders were pick from the start time to end time at each hour. For example, Column A is the Start Time, Column B is the End Time and Column C is the number of orders picked. Let's say i need to calculate how many orders I picked...

Hello everyone. I'm having troubles with a huge file I'm trying to reduce. I have a list of almost 280k sales orders that it's slowing the file (and the whole computer) down a lot. For my purposes, I realized I can reduce that drastically by summing up the number of orders per month, instead of...

I am trying to get excel to return a date from a list of orders from certain companies. This list has the same companies just different dates and i need excel to return the latest date. =INDEX(Orders!B313:B419,MATCH(1,(Orders!A313:A419="*"&F3&"*")*(Orders!B313:B419>N3),1)) F3 is the name of...

Hello, I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date. Example...

Hello all, I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers. Calculate released quantities against the estimated beginning quantity to know how much remains...

Hello All, So I am trying to determine how many orders my provider entered by noon, also how many discharge orders entered by noon. It seems Access has two common criterias I can use, And is one, and Or is another. I want a query that gives me both the numbers of orders and discharges...