In my drivers database I need to show drivers between age 25-35: I put this in criteria:
<Date()-9125
>Date()-12775
(12775 days= 35 years, 9125 days= 25 years)
what is the correct way to do this filter?
ex. I have a database of customers, and the dates by which they should have paid their debts to me. I need to charge interest from those are late.
It must be based on a primitive system of DOUBLING the sum each month not paid.
1.1 - 250
1.2 - 500
1.3 - 1000....
Can someone help me do it in...
By the way, a better example to what I mean:
I have two tables:
Windows Users
Access Users
Let's say I work in Microsoft and I want to encourage Windows Users to use Access. For this I need to create a query with Windows users that do not use Access.
how can i make a query about people who appear in one table and do not appear in the other table?
for example:
table - sex workers:
1. Monica
2. Linda
3. Daniel
4. Mahmouda
table - blonde prostitutes
1. Linda
2. Daniel
Querry that I need:
NON BLONDE PROSTITUTES.
Needs to show:
1...
thanx. by the way - i have a new problem.
i need to show all the drivers between 25-35 with 0 fines.
which means all those who do note appear in the table of fines.
so now that I know to calculate the age, how do I choose those with 0 fines?
only people who actualy got a fine appear in the...
by the way - it works!
now I have
"John Doe - 3"
"Baba Sali - 1"
Wow Wonderful thank you very much! you save me! :cool: :)
I added a "control number" in the fines table - always "1". so when it summarized it in the query I can see the number of times the driver parked illegaly.
Now I can...
I have 4 hours left to submit my work in access.. which is a 1.5 pt course required to continue.. I should have done it 2 days ago but I asked for another 2 days from the professor.
Okay so all of people who really use access should probably now it... I have 3 tables:
- Drivers - License #...