Search results

ACP is a field in the query, as shown in the screenshot of the query.

There is a chance this scenario never occurs but through testing this AVCO feature it seemed a possibility. Another possibility is if a purchase needs to be retrospectively entered, i.e. if a purchase delivery was not recorded on the day it arrived. Like I say, this might never happen but when...

Thanks very much for this info, I was definitely over complicating it thinking I needed a function. I have been able to use your calculation to get the AVCO via a calculation field in a query. It works great when a new purchase record is added as the last record in the query but not so well when...

Thanks, I definitely want to stay away from storing the AVCO. I have been instructed by management to introduce the average cost for each product in such a way that reduces the requirement of updating values manually. We have a history of our prices being inputted incorrectly and therefore...

Hi all, I'm hoping for some assistance to help me build a function which calculates the average cost price (ACP) of our stocked products. I have had a look online to see if anything already exists but couldn't find anything suitable. I have attached 3 examples taken from an Excel workbook to...

Haha, I was missing something with the code - it was as simple as that! Thanks for your help all the same :)

Hi everyone, I have been using Allen Browne's Inventory Control code for quite some time now and it has been working perfectly. However, there is now a requirement for one of the stocked product's quantity on hand to be displayed as a decimal number. I have changed the data types of the table...

Thanks! And is it possible to have multiple subforms of crosstab queries on this form controlled by the command button? All the subforms would display similar results but with slight changes to the query where condition.

Perfect, thank you for your assistance :) Just a couple of questions regarding this setup: Is it possible to add a Sum totals for each column on the crosstab? Is it possible to add multiple subforms which are controlled by the one command button on the form?

02/11/2021

I've got the where condition working as below but I am still unable to figure out where the date formatting goes in the function, I either get an error or no formatting at all. @arnelgp can you point me in the right direction? "TRANSFORM Max(Customer_Orders_Items.Order_Quantity) " & _ "SELECT...

Ok, I tried to add the format to this part of the code "PIVOT Shipments.Despatch_Date IN (<exp>);" _ but I wasn't able to get it to work and get a compile error. Whereabouts on the function does the format go? I also tried to add the where condition to the 'cons_query' section of the form...

Amazing, thanks so much for this. I have almost got it working with my database but as my table structure is more complex than your sample I need to make some changes to the code. Below is what I currently have for my version of the code for 'cons_query'. "TRANSFORM...

The date columns shouldn't need go above 150 so 255 limit won't be a problem. Would you be able to provide some more detail about the For...Next Loop (as I have never used one before). The smallest date will be the current (today's) date. Also, where do I reference to the function for it to...

Hi all, I am trying to make a crosstab query with a date range as the column heading. My 'Shipments' table contains a field called 'Despatch_Date' and I would like the crosstab query to use this data as the column heading starting from today's date through to the maximum date in the data...

I found a solution here: https://stackoverflow.com/questions/35631335/changing-printer-in-vba-for-access-also-change-page-layout Carton label code works perfectly for what I need, pallet label code doesn't need to change. Private Sub Command2_Click() Dim DefaultPrinter As String Dim...

Thanks arnelgp, Where do I add this part of the code into your suggestion? prtr.TopMargin = 0.5 prtr.BottomMargin = 0.5 prtr.LeftMargin = 0.5 prtr.RightMargin = 0.5 prtr.PaperSize = acPRPSUser prtr.Orientation = acPRORLandscape

Hello! I'm hoping for some advice and guidance but first a little bit of background on my set up: The office has two PCs and two printers, the default printer is called "+25" and the other printer is "Zebra Printer". However the Zebra printer is also called "\\4H1Z742\Zebra Printer" because...

That looks to have done it! It will be thoroughly tested over the coming weeks but I think it is working perfectly. That has made my day, thank you so much for your help :)

Thanks so much, it is so close to working! The problem I can see is when there are multiple order shipment numbers for the order. I have added 16172B to the data and I'm getting the results as shown in the example database attached. It's working perfectly when there is just 1 shipment number...