Search results

Is this free sir?

Yes!!!!!!! After considering all your comments, i think i am now able to make solution to my problem. I will post here my final output and let u evaluate it again. Thanks.

The Tax Table represents this one. It is a reference table. The EmployeeTaxingPeriod represents: 1 = Daily, 2 = Weekly, 3 = Semi-Monthly and 4 = Monthly, so it means like an employee receives a semi-monthly salary or he is being paid after 15 days and is tax on that payment base on his salary...

Hehehe jdraw dude, I am very thankful of all your replies, because it really helped me a lot, it was just an expression :D but sorry if it offended you or whatever. Uhm again, so i take into consideration that lookup evil and now i have tested to create another db with only that tax table and...

Uhm, now im getting confused, jdraw ur making me read, reading is killing me, i learn when i do things. xD But again But, uhm i already made [ETPES] InitialTax: DLookUp("[InitialTax]","qryreftbl_WTAX","[ETPES]=" & [ETPES]) The code above can actually find the first record having that...

uhm, if that is the evil case, what should i do? xD [edit: uhm ok wow, i will just adjust my db sometime] But, uhm i already made [ETPES] InitialTax: DLookUp("[InitialTax]","qryreftbl_WTAX","[ETPES]=" & [ETPES]) The code above can actually find the first record having that [ETPES]. Now i...

Uhm, when i put that Currency function, it does not lookup the proper value and if i click on that #Error it shows:

I got a #Error sir. Here is an earlier version:

Hello everyone! Uhm i have a problem regarding this DLookup, and if i am able to solve this problem i am sure to unlock many possibilities in ms access. Ok heres the problem: I have this payroll system: In the "qryEmployeeWTax" i need to Lookup the [InitialTax] from the "qryreftbl_WTAX"...

Thank You very much for the help. I am looking into your solutions and suggestions but uhm i got something in mind, and it uses only 1 query, without using vba. If it works, i'll post it here. But right now, i got a problem with this: DLookup with 3 multiple numeric criteria, xD.

Uhm, actually for now, this is just an initiative of mine making a database of our school so that we can track things in our enrollment instead of making manual logs, so that we know what is the exact amount that came in and for what, how many enrolled to this level, who are the new/regular...

so uhm can you tell me that specifications/details that you needed to know?

Hello Sir, thank you very much for the reply. Uhm, what is that Data Structure you are talking about? sorry, i am actually a noob trying to enter into your world, i build this database copying the idea from time and billing template of microsoft in invoicing. btw here is the copy of the...

Hello folks!, uhm i am building an enrollment system in my school and i have created a report which gives the summary of enrollment. Specifically it will provide the summary of male,female,foreign,local,new,regular, as well as the total number of enrollment per level per department in our...

Yes it is. oh ok now if i did not format them to percent it was fine. Thank you very much.:)))(i guess solved now) BUT, why was it not functioning well when they are formatted to %? :D

thanks for the reply. well actually, when i changed it to number it won't return anything. and then how bout the "qryStockStatusSuccessPicks" is something wrong with the criteria under SPL%change? i would actually like to query stocks price difference above or equal to based on my...

same as the title goes, why i can't query those figures greater than 15% only? How am i suppose to query them right?.Here is my database you cant check query1 and query 2. I am using Ms Access 2010. Link: www dot dropbox dot com/s/n3iuev1c5e0dfby/StockMonitoring.accdb sorry i can't link...

Hello to all, I am Jodill James A. Esteban, 21 yrs. old. I live in the Philippines, currently residing at C-10 Nepomuceno Street, Barangay Santo Rosario, Angeles City Pampanga, Philippines 2009. I am new to Microsoft Access and i am loving it so i would like to have an advance knowledge about...