Search results

To flesh it out a little, here's the query I'm using at the moment.. SELECT [GWPI-Combined].[Agency Number], [Commissioned Expenditure Data].[G/L Account No], Sum([Commissioned Expenditure Data].Amount) AS SumOfAmount, GSC_CRR.[CRR Value], [GWPI-Combined].[GWPI 2012], [GWPI-Combined]![GWPI...

Morning folks, I'm delving into the world of Access again and have run up against a little issue.. I have a table of expenditure information against a number of accounts. The data is broken down on G/L code, Cost Centre and a number of other elements. I need to be able to suppress spend...

Nigel, that, is blooming fantastic! Unfortunately, I can only click Thanks once!!!

That link was appreciated.. I will be designing routines to add/move/retire hardware from the database, so will use values from the additional tables at that point to force the selection of correct data.. Cheers.

Joins I can cope with... Hi ho, hi ho, it's off to kill lookups I go... Big thanks for your help Paul..

Thanks for the code Paul.. I've ameneded the necessary entries (those in blue) and changed the properties of the listbox to be a value list.. ........ but... Unfortunately, it's still pulling the IDs rather than the values.. :( harrumph..

Thanks for responding.. I'll amend the change() to AfterUpdate(), thanks for that one.. I wish to display data from all of the fields mentioned. The intention is to show assets attached to the site in question. The listbox has 7 columns. I guess I should add that the hardware table is...

Forgive me, for I have sinned. It has been some time since my last post and an almost equal amount of time since my last piece of access development. (Enough of that melodrama, let's cut to the chase).... I'm building a form on which I want the end users to select a site reference from a...

Perfect, thanks both..

That's where I'm heading at the moment, but I'm getting some slightly peculiar results on some values.. Query8 StoreRef Aisle AisleLen 13C45 13 2 13C46 13 2 13D11 1300000000000 13 13D12 13000000000000 14 query is as follows.. SELECT...

Folks, any thoughts on this one? I need to find the position of the first alpha character in a string, the section of the string prior to the alpha character is variable in length, hence I need to be able to find the position to feed to a left/right/mid style expression to be able to break down...

Perhaps I should have searched first! http://www.access-programmers.co.uk/forums/showthread.php?t=218030&highlight=rounding Issue fixed... New expression is : Fix Time: -Int(-(Sum([dbo_ReportData].[Fix Time])/0.25))*0.25 Thanks for being here access-programmers.co.uk!

Morning folks.. Having a little fun with rounding at the moment... I've made some progress but am running into an issue, purely due to the way that I want the rounding to work.. I have times output in decimal style (due to the originating data source) and need to retain the decimal style...

Morning... After a bit of digging around on Friday I managed to resolve the issue.. It would seem that I just needed NZ, but was approaching it in the wrong way.. I spend a lot of time in Excel, so was expecting an "expression, result if true, result if false" style syntax, needless to say...

believe me, a database re-design/rebuild would be lovely, but, as per most solutions, this solution doesn't exist in ideal circumstances.. My DB has an ODBC hook to a SQL database holding the table dbo_reportdata, this data is historical records from our call logging/CRM system. There is then...

Sorry to bounce this, but I'm still trying to work out how to do it! Any thoughts gratefully received..

Thanks for the reply Bob.. I think I must be doing something wrong at a more fundamental level. When attempting to use my code (with your suggested amendments) within a query, if that query element is set as "group by" I get: Cannot have aggregate function in Group By clause: Switching it...

First Receipt : IIf(Min([dbo_ReportData].[Received Date])="",[Liveval].[Received Date],Min([dbo_ReportData].[Received Date])) I'm guessing that IIF doesn't play that way? Well, I know it doesn't, I'm getting aggregate errors when attempting to run the query.. I need to pull a value from one...

Any thoughts folks?

Afternoon all.. I've made a return to this query, as we finally managed to review some of the data on Friday and have decided that additional information is required in this particular report.. So, to that end, I need to extend the dcount to include data from a 2nd table.. I have extended...