Recent content by ecorg911

I'd just like to thank everyone who has helped me out during the last few days, as I have had a mission-critical project. I couldn't of managed it without the help and support of this community, which is rare these days :P In paticular: dkinley pbaldy Thank You! :)

Thanks, spot on as usual :), I think I will go with the checkbox method, as I can implement this with ease. Thanks again!

Sorry, I think you misunderstood me. My wording was poor, what I am trying to accomplish is for the user to enter data and then make Access verifiy with the user if this is the correct data they wanted to enter.

Hello, I am currently trying to implement a validation rule to a specific field, although I can enter validation rules and they work correctly. Though is it possible (and if how so) to "flag" the field if no data is entered or invalid data is entered, and then come back to it later, without the...

Cheers mate :)

Hello, I am having a few problems with a calculated field I am using in a query: Result: IIf([Units in stock]>100,0.75*[Unit Price],0) When the field outputs, it appears in decimal formatting, how would you change it to currecny formatting? P.S. I realise this operation is straight forward on...

Thank you both for your input =), I will try out these methods now and let everyone know the results :) Edit: tried pbaldy's solution and works great thanks! I would have tried DK's, but I think it's a little beyond my knowledge of access ^_^ Thanks :)

Hi, I am currently trying to get a query to only output data that was "added" to a table in the last three months. I have produced the following, although it is a poor way of getting round the problem. Could someone help me create a more efficient query. E.g. so the database would automatically...

Thanks worked like a charm :)

Hi, I currently have to add up all values of the "Total" field in my query and then implement a "Grand Total" value on my report. The formula for "Total" is: In this case, what would be the formula to add up all of the values (in the "Total" field.)? Any help would be greatly appreicated...

:O I just thought of that, trying it now :) Thanks :D

Hi, Prior to my earlier request I am in need of help again :) I have a table with several fields - Price, Product and In Stock etc. I am trying to create a report that will output these fields, although the "In Stock" field is a "Tick Box". I only want to display the values that are "ticked"...

Cheers mate, much appreciated, you've saved me a lot of time. Thanks :)

Hi, I am currently having a few problems using Queries in MS Access 2007. I am currently trying to make the query multiply to values, although only if "value 1" is above a value of 100. For example: Value 1 Value 2 Result 16 23 Do not mulitply 113 7...