Search results

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

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.

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

Does anyone know why Microsoft sometimes use such complex Help examples? Often I find the example code in which they have demonstrated a function is so complex, I can't see the wood for the trees. I thought a basic maxim of teaching was to demonstrate a principle in the simplest way possible?

It overwrites characters 1 & 2 with 3 & 4 Ie if I enter PR21 I get (keystrokes in brackets) (P) P (R) PR (2) 2R (1) 21 and then it tells me the data doesn't match the mask. I have since found out I can't use autotab on a combo box any way, so there may be no purpose to the input mask, since...

I find with access I am the limitation not the software.:) I am no computer propgrammer, but I have been able to build myself some great little databases to do various bits and pecies ythat used to take me ages. Recently completed an a database for all our in house training records, which...

I have a form that opens a query, a comob box on the form restricts records included in the query, to the department selected. E.g if I select "GradingRoom" only records for employees who work in the grading room will be included. The list of available departments is in a table which does not...

I am trying to speed up a data entry form, by adding input masks and autotabs. Box1 is a text code made up of two required letters followed by two required digits. The underlying feild is a text field, the field list surce ins a text field in another table I am using LL00 as the input mask...

Most 'Design' Is Not Intelligent, babel fish Disclosure Statement: I am a marine biologist, I accept the theory of natural selection as an explanation for the phenomenon of evolution, I do not subscribe to any faith, but like most I have things I beleive in that are without logical support...

Hi, Can anyone see what the syntax error in filter criteria in this code is? If CurrentProject.AllForms("TrainingRecs").IsLoaded Then Me.Filter = "Total Name =" & "'" & Forms![TrainingRecs]![TotalName] & "'" ElseIf CurrentProject.AllForms("ReportTrainee").IsLoaded Then Me.Filter = "Total...

Hi, I have a report which contains employee training records. It is set to only show records for one employee at a time via a criteria in the name field in the reports underlying query. (We use the printed report as an annual training record signed by employee and trainer). There are three...

Hi, I have a form which shows training information for employees. The main form shows the individual's details - name, job etc. The subform shows the various training courses the person has completed, and the level of competency attained for each. I want to prevent users from...

Thanks Thanks for that. I know how to import into Excel automatically, so I will use that option. If I have the spreadsheet preserve formatting whenever the data source is updated, then I guess I only have to format it once. You would think Microsoft could get their act together to allow...