Search results

oh so it is switch (case) statement but in a function to get round the nested IIF statements, well that is certainly helpful as i have a number of places i have used the nested IIFs that would be much much easier to understand using that

@arnelgp i had a sneaking suspicion that it would end up being a new query based on this one and sort that, but was just curious to see if it was something i was doing wrong i am not aware of the Switch() function i'll look it up in case it helps me in the future, but i'll try the second query...

Hi All I have the following fields in my query calculating various values but in the end i need to know the Percentage of Waste value. This is working ok but i would like to sort based on the WastePercent field grouping anything 5% or less together, anything between 5% and 10% together and then...

@MarkK back from my christmas break so thought i'd update this thread, the fix of updating office resolved the issue yes thank you

so i got KB5008212 and servicing stack 10.0.19041.1371 neither of which are listed in that article, but still having a windows security update overnight and now it does this points to that as the issue i'm going to role back the security update and see what happens

@isladogs thank you for this, whilst annoying at least it explains it

Public Function initVars() Dim strUserName As TempVars Dim NameSpace As Object Set NameSpace = CreateObject("Outlook.Application").GetNameSpace("MAPI") For Each Account In NameSpace.Accounts ' If you want to see more values, uncomment these lines 'Debug.Print...

Hi All I have a shared folder with the backend of a split database and users access it via a front end local to their machines. If no one has their front end open i can open the front end on my local machine accessing the backend via the shared folder on my local machine. If someone else...

@theDBguy worked like a charm, awesome thank you

@theDBguy yass, i'll give that a go thank you

Hi All I am creating a report that shows a limited selection of records and the details section is now pretty much set but i need to add a little bit of summary information in the report header as follows: I want to gather the first and last dates from the listed records and show a to and...

@CJ_London thank you for following up, i'll take what you've stated and run a few tests

@The_Doc_Man yep that works: SELECT [FACT-Consignments].cons_albaran, Sum(Not [del_prod_return_received]) AS Expr1 FROM [FACT-Consignments] INNER JOIN ([FACT-Deliveries] INNER JOIN [FACT-DeliveryProducts] ON [FACT-Deliveries].del_id = [FACT-DeliveryProducts].del_prod_del_id) ON...

@CJ_London thank you, i'll take a look at your solution because honestly i was just messing about with things and stumbled upon something that appears to work but might not be the best way of doing it. thank you for your message

i think (think) i've figured it out SELECT [FACT-Consignments].cons_albaran, Min([FACT-DeliveryProducts].del_prod_return_received) AS MinOfdel_prod_return_received FROM [FACT-Consignments] INNER JOIN ([FACT-Deliveries] INNER JOIN [FACT-DeliveryProducts] ON [FACT-Deliveries].del_id =...

Hi All I have sets of records that all have a reference number and a status that i would like to query as follows: For example: This would show 1 line for M00158 with a consolidated status of No as not all the records statuses are Yes This would show 1 line for HLBU9503742 with a...

@Pat Hartman thanks for responding, it is much appreciated. i want to learn better ways to do things as i come from a development background in things like c++ etc so my go to is "code it" and i have no sql/query/database experience so this is all new to me. i usually know what i want to achieve...

CommOpen i think is VBA https://social.msdn.microsoft.com/Forums/vstudio/en-US/0ae75bee-de1a-4551-827b-d6e9cdac744f/control-serial-port?forum=accessdev

this might be of help - http://www.thescarms.com/vbasic/commio.aspx

@Pat Hartman thanks for the feedback, i'm not sure "no reason" would be accurate, the above code was using an example, there would be potentially 10s of combinations of the consignment parents to delivered products children i'd have to requery many times getting totals for the deliveries under...