Search results

so after testing and checking etc it happens that the findfirst and dmin business was not returning the right results. and re-reading the above thread i think its because the "Valid To" dates are not ordered, they are all over the place. findfirst (as i understand it) won't work with...

@theDBguy @CJ_London you guys are da best, thanks a million for the update, DMIN is a new one for me so now i'm aware of it at least in the future (hopefully) i'll remember and make use, i'll update this with "resolved" once i've implemented the solution and tested it out

@CJ_London awesome i'll give that a go, and yeah it all makes sense when you are doing it, and only when you try and describe it to someone you notice that the terms are a little confusing, yes the date is a "Valid to"

i guess what would be a better way to describe it would be that the price date in the table is the last arrival date the price is valid for

the arrival prices are any date from 30/10/2021 to 05/11/2021 should show a price of 5.50, anything up to 29/10/2021 should show 5.00 and anything from 06/11/2021 to 12/11/2021 should show price of 5.75, if an arrival is after 12/11/2021 it will show as no price available yet but prices could...

@theDBguy it would be the record dated the 5th as the arrival date is before that, it shouldn't pick up the 29/10/2021 and shouldn't pick up the 12/11/2021 (hahaha just had visions of the holy hand grenade instructions from Monty Pythons Holy Grail) so for the arrival of 02/11/2021 the price...

Hi All i hope this one is a simple one I have a form that the user enters some information into and then a button to look up latest price for the input they have given and populate that on the form as well. My price table looks like this: Price Table Customer Arrival Date...

@arnelgp i'll download and take a look and @isladogs i'll take a further look at the link

@isladogs @CJ_London @arnelgp thank you for your responses, i resolved the issue by doing the following: Add all temperature values to an unsorted arraylist Removed duplicates from the arraylist and sorted it Counted the number of elements in the array list to find mid element Divided 255 by...

looking at a HEX colour picker: RED: 255,0,0 to WHITE: 255,255,255 as long as the 2nd and 3rd hex digits are the same and go up in regular intervals then it will be a RED getting lighter till it gets to white BLUE: 0,0,255 to WHITE: 255,255,255 as long as 1st and 2nd hex digits are the same...

Hi All trying to figure something out wondering if anyone had any pointers/ideas on best way to achieve the following? I have some temperature data for dynamic period, as in can be any number of days, that i'd like to assign colours to based on relationship to min and max temperature. I have...

@CJ_London thank you, yeah i do try to reduce the width of things to fit on a page, and most of the time it works, but i'm finding more and more the reports that are required to be generated are just too wide to be displayed on a form or a landscape sheet of paper unfortunately, but i have been...

@CJ_London thanks for the update. i actually had an idea in the shower (as where all good ideas start): User has a form to filter deliveries and select which ones they want to report on, the selection is an IN clause for the query on the delivery IDs, and the query is exported to an excel file...

ok so what the user will end up with as an example will be: Where the currency 1 uses the same currency field, currency 2 uses the same currency field and currency 3 the same currency field to display. The data is stored as: This is a very simplified example but different customer will...

@arnelgp thats what i am trying to do but i want to understand how i can format the columns of data so that they display the correct currency on each of the columns based on the currency field that relates to them and then make sure the totals column has the same formatting and if its not...

Hi All I have a query that needs to display: Price of bought product Total value of bought product Price of transport product per kg Total value of transport of product Price product will be sold at Total value of sold product Value of customer claim All of these values and prices have an...

@Pat Hartman i have kind of ended up doing something similar but have come in from a different point of view based on the way in which the users currently work, in that the search form has the comboboxes and date text boxes which allows the users to reduce what they see from the main list down...

i'll continue to dig in as it looks interesting and i'd like to understand it more but i'm not sure its what i am looking for as the main "excel" like view is only 1 table of normalised data. its not bringing multiple tables together more it is improving the way the data from the 1 table is...

@jdraw thank you i'll take a look

Hi All I have migrated my company from a spreadsheet to an access database to run the day to day business by sanitising, normalising and then modularising(sic) the data into a more logical format. We used to run things from a sheet that had 4000+ rows of 270+ columns the majority of which are...