I've come to a bit of a problem with a query and not sure which to choose from the above so any advice would be great. I'll try and explain what I want..
At the end of the year I need to do accounts and the way it is produced means that each entry gets converted to a number. Most of the entries are converted by a combo box, set the column with the number in as it is entered in the form so that is fine. I then use a query to sort out the columns as I need them, groups then and spit out a report.
However, on this report and for the main query I need the fieldname Strain to produce one field in the query as the Strain and another field in the query as a number. So I used switch i.e.
Switch(tblanimals!strain = "Freisan";1; tblanimals!strain = "Jersey";1; tblanimals!strain = "Black";3 and so on.
This works fine. However, if I need to add more criteria then it's not very easy and I think there is a limit to the number of criteria I can put in.
So then I thought I would make a combo box like before, but I can get two different query fields from one field source.
So then I looked into Dlookup to do the following: