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...
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...
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...
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...