Recent content by mamandeno

I missed this in my original read of your post, makes sense, thankyou.

Thanks. I have no need to run reports using this query in access. So, all good there. Also thanks for that explanation.

1) Great call. There were a few null or blank values in some of the older data. Adding ">0" as a criteria to the field I was using in the calculations has everything working as it should. There shouldn't be because we have validation rules, but that's a separate issue, the query now works. I...

I have >100k records.

Thanks for the replies. Lots of food for thought. I think I can simplify things somewhat. I'm dealing with an old and creaky database that I did not design/build. I need to match multiple harvest records to one crop record to work out yield. Unfortunately, the required info lives in...

SQL VIEW as requested SELECT MusselCrops.CropNoKey, Sites.AreaCode, MusselCrops.SiteNo, Longlines.LongLineID, MusselCrops.DateSeeded, MusselCrops.TypeSeeded, MusselCrops.Con_SpatBatches, MusselCrops.RateSeeded, MusselCrops.SizeSeeded, MusselCrops.LengthSeeded...

Sorry, I'm having a little trouble with it. I'll post the expressions Months_to_MinHarvestDate: DateDiff("m",[DateSeeded],[MinOfHarvestDate]) Kgm: [SumOfFactoryNetGreenWeightKgs]/[LengthSeeded] Expr1: [Kgm]/[Months_to_MinHarvestDate]/12 The first two calculated fields are working. The third...

I have a select query within which I want to add a calculated query (Expr1 below), that uses another calculated query (Kgm below) in it's expression. I have set the format of Kgm in the query to fixed and limited it to two decimal places. The problem I'm having is that Access isn't...

I am with you on those fresh veges Gary, Our house is on 1 acre (0.4 Ha) of land and I have dedicated 25% of this to food production. About half fruit and the rest veges. This time of year is fantastic, fresh zuchinnis/courgettes, tomatoes, basil, egg plant, chilli's, red onions, coriander...

Thanks eveyrone for their responses. Interesting to see the range of opinions I would really value some more comments about whether or not people will change their shopping preferences for environmental reasons. Rich thought most people wouldn't tolerate extra cost to be nicer to the...

That is funny - you have wonder what the stores would have in their respective basements!! Would any guy get past level 1 in the wife shop.

That's interesting. I work in an industrial building and all our emergency lights are floruresecnt tube fittings which are the same system as the compact floruesecent energy effiecient bulbs. Filament style bulbs are not preferred for emergency lighting system here because we have a high risk...

So Rich, you reckon people won't spend extra to buy environmentally freindly food? I read about the light bulb thing. Madness, lighting is typically only a few % of householed energy consumption. I got all enthusiastic and put compact flourescents in at home. They are OK and do save power...

Marriage? So who invented marriage - God or the devil? 'cause that puppy will take a woman from size 9 to size 14 in a matter of weeks!! :D Oh yeah and eat NZ Greenshell mussels - low in fat and cholesterol, more iron than steak, high in protein, high in omega 3 and real yummy. Mike

I would be really interested to gauge peoples interest/views on this topic. Food miles is a concept currently being batted around to try and represent the amount of transport that goes into a food product to get it into. The idea is that this approximates the carbon burnt and therefore global...