Search results

Thanks a lot, this was the final thing i had to do with this database. I'm glad to be seeing it gone!

I'm having a problem referring to fields that are in the same query. What I have is one field with a large formula (called discount). I have another field with a formula (called price). I'm wanting to make a third field which takes the discount from the price. If i use the build command and get...

Thank you very much guys!

I'm not quite sure what to search for on this, so here's my question. I'm wanting to do a standard counting field in a query, but with criteria i'm not sure how to write. I want it to count the number of a certain field (In this case Turkey ID (don't ask)), which i know how to do. It is...

The round function is only to a certain amount of decimal places, and the Fix is to Integers only i think. I'm trying out the code by Kenhigg now.

I don't think it'll work as what i'm trying to edit is either the field entering code in the form or the forms code. What I really need to know is which private sub i should put it in.

I'm trying to create some vb code to create some kind of validation so i can check whether a number inputted is 1dp and to a half e.g. 0.0, 0.5, 1.0, 1.5 etc. This is for a form btw. I've tried with the standard validation settings but i can't find a way to do this. I have some code which i...