Search results

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

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

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

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