Search results

Thanks for the suggestions. ill explore crosstab queries. I'm also looking in to using something like the Vlookup function in excel. (y)

Can you please expand, I have just had a look at total queries and I cant see how they would be of use? I need the raw data stacked end to end if that makes sense.

Hi all, I have a table with numerous records in a access table in the following format: Debtor_AC_No PIM_No Trade_Name Premessis_Type Bin ID Bin_Size_ID Emptying Cost Bin Cost CollectionNo IndivCost Rental Trade Rental S2 00177847 PIM:01154 The Bank Trade - Bins 979 T 140 £2.80 £27.50...

Roger that. I’ll give it a go next time I’m at my PC I’ve also changed the query name to: IndivCost As per your recommendation. Thanks

Just tried the DLookup idea: =DLookUp([Cost],[Collection Costs (individual)],"[BinID] =" & [Bins]![Bin ID]) same result as before. Is there a preferred way to do this? Thanks for the suggestions

Hi all, I have been trying to use a query with an expression as the control source for a continuous form but all I get back is the dreaded #Name?. The query itself is, Collection Costs (individual) and im trying to use it in my Bins subform to show the total cost of a bin collection. I use...

Thanks dude :D Just as additional background what's up with using the above? if you don't mind.

Hi all, Simple one today, I have a form with financial information in, namely how much a service costs and how many times a year the service is required. To get the total cost I simply multiply the service cost by the service requirement using a function box. However I have found that the...

Roger that, Thanks for the advice.

Thanks for the reply's, So using this method as part of a larger more complex query could be complicated, would you suggest when I need to carry outhits function simply doing it as a sub query? Thanks CJ this is a nice simple example of the syntax for me to follow.

Hi all just trying to expand my knowledge of group by and other such functions so I can get useful information from my data and I would appreciate some help. The attachment shows a sample of data I'm working with, just two columns to start; Bin ID & ID. My aim, to count the Bin ID's but to...

Roger that Minty. im treating the notes section sort of like a doodle pad as there are those in the office that are.... averse to change... and don't like keeping all digital records instead of having paper everywhere. Im using it more as a space for those people to scrawl their notes and...

There's only ever going to be one record so one table is the way to go I think. Thanks for the explanation dude. This table was originally set up to be a sub form within the Main form with a 1:1 connection with the ID field thus I kept it simple and included only one ID as the form itself...

With reference to the above, would you recommend changing the Note ID to number? or is there a better way to sync everything up? Could I place the ID field from the TWA form in the notes form and use that to call up the form in the same way as before? Also I removed all the Note records...

You are a god send sir, I knew it would be something simple. Just to clarify for future reference. If I reference an field in a form, it must be present in the form even if the data itself is included in the source table? Is there a way to reference the table? ooooor should I just keep it...

Minty, Why are two unique ID's required? My thinking on the situation was that as both the TWA & Notes record essentially hold the same ID for each shouldn't it be as simple as saying find both ID's that = 8 and open the form? sorry if im being dim I just want to keep it simple as possible

Im uploading a copy with all personal info removed but with all the relevant info needed for the query still included. The button marked 'Not in Use' is the one that holds the code in question.

The form 'Notes' holds two fields: ID Notes The field ID in the form 'Notes' is linked to the field 'ID' in the form 'Trade_Waste_Address'

One of the variations tried was to try and call the ParentID (As this is what 'NoteID' used to be prior to me renaming it for reasons that you stated previous) However I was still left with the issue of needing to manually input the ID for the record to display. For clarity the WHERE...

Hi all, As the title says I am trying to open a form (as a pop up window) from inside another form. For context the main form is called 'Trade_Waste_Address' and the form im trying to open is called 'Notes'. Each has their own ID field called 'ID' & 'NoteID'. Im attempting to call up the...