Recent content by Ashkan

thanks :D

if the final price of the item is less than $75, then there is a 5.25% fee. if the item sells for more than $75 then the fee is calcauted by charging 5.25% for the first $75 and 2.25% for the reminder could you please give me the code required to calculate this?

in a report, i am trying to do it in the control source

how would i do a function i am new to access

Hello, I am making a small DB in Access to track my Ebay sales. I have a table with a SoldItems field. I want to make a report that will calculate the Final Value Fees so I don't have to enter it my self. If the Final Sale price of an item is between $0 and $75 then I will be charged 5.25%...

Thanks Wayne :D

I used the following and it worked: SELECT ContractNumber FROM tblContract WHERE month(ContractStartDate) = 11 AND month(ContractEndDate)=12; But I need it to retrieve ANY records that INCLUDE the months 11 and 12, for example if the contract start date was 01/09/2004 and the contract end...

Hello, I need to create a query that searches the contract start dates, contract finish dates and returns the contract numbers of any contracts that INCLUDE the months 11 (November) and 12 (December). This is what I have done so far: SELECT ContractNumber FROM tblContract WHERE...

Thank you :D

I have a table named Contracts. It has the fields Contract ID, Contract Start Date, Contract End Date. I need to be able to produce a query that will contain all current contracts. Any ideas??? :( Thanks Ashkan

Hello people, I have two tables, the first one is House which contains the attribute House Name, the second table is House Room which contains attributes about the room. My question is how would I go about finding out how many rooms are in each house? I hope this makes sense :rolleyes: Thanks

"Rub off the "Valdation Rul" and fill up the "Input Mask" properties" what do you mean?

what i meant is that i need a validation rule that only permits the alphabetic characeters between A to Z thanks

i need some help with a validation rule, i need a rule that permits only A to Z characters of any length. i searched but i could only find rules that allows A to Z but of a fixed length. thanks ashkan