Search results

Im not adding to a table. I have a form and a query also. Im just trying to find out how to store a value in a field automatically by using a iff statement

Hello everyone. I hope your holiday went well. I have a very easy question regarding if statements, when I say easy that means not for me but for you. here the problem. I have a table name main table , which consist of 4 fields. 1.date 2.driver 3.violation 4.violation_number. Now what I want to...

thanks for the quick response, ill try something new

So just making sure, i will have to add a field that i can place in the table for instance " count " and when that person is late I put a "1" in that field, and the next time 2, 3 and so on. Then use conditional format like "[count] = 1, is yellow, [count]=2 are orange and so forth? I was...

Hey every body, I hope your day is going better than mines. I am working on a project that determines how many times a employee is late, and i want to use conditional formatting to display the amount of times listed. for example( Carl Williams was late on 3/4/15) so my report shows that...

what im trying to do is, lets say i have 3 fields. 1.amount,2.listbox with 2 selection "expense and income", 3 total. lets say i put 5 dollars in the amount field, then select the list box to income, i would like the total field to show 5.00$, if i select expense i would like the total field to...

Hello everyone. im new to Access and willing to learn and someday be able to help someone. Here's the problem.. i need a code or someone to show me how to fix this problem... im working on a personal expence ledger. I need some assistance on a particular field that is labeled [expence/income]...