Recent content by maabbas

Both sets of data are in the same table.

:banghead: i need to do this, i change the question

i am looking for some advise how to create a query from Bill of material table, bill of material table looks like below FinishedProduct,ItemNumber 64000,7975 64000,7685 64000,7695 64000,6444 6444 is WIP Same table has Work in process (WIP) information, FinishedProduct, Item Number 6444...

Thanks for reply, will you please explain little more?

I have some reports with criteria and I want these report to save as PDF in different folders on network Currently I am using the button and following code to export report. Private Sub Command1_Click() DoCmd.OutputTo acOutputReport, "Report1", acformatepdf...

sorry I post the wrong Senario

Thanks! my friend you are a Star, so far its working and not find any issue. Thanks! again

getting "circular Reference caused by PointBalance_Sub3" error

please see the table Attendance Attend_ID Attend_Date ID_Employee ID_Point 1 1/1/2015 1 1 7 7/1/2014 2 2 8 9/1/2014 2 1 9 1/1/2015 2 1 10 2/1/2015 2 1 11 6/21/2015 2 1 12 2/1/2015 3 3 14 4/5/2015 1 1 I change some data to test, see ID_Employee "1" he has absent on 01/01/2015 and 04/05/2015, he...

Thanks you very much for your help, I will test the file and let you know

he will have 6 points

1. Yes only point assessment going into attendance 2. Here is data from Table Attandance ID Attandance Date Employee ID Points ID 1 1/1/2015 1 2 2 3/31/2015 1 2 5 4/2/2015 1 2 6 1/4/2015...

Thanks for reply, the main object is to calculate points, I have only test data, Attandance Date Employee ID Last Name First Name Description Points 1/1/2015 1 Abbas M CO 2 3/31/2015 1 Abbas M CO 2 the...

Hello Everyone, I need your guys help to start, I am trying to create an attendance database, our company introducing the point system attendance, Called Off (CO) 2 points Left Early (LE) 1 Point Tardy (Tar) 1 point Employee can reduce point if they have perfect attendance...

Sorry Everyone I was in hurry did not describe my question fully, also I search the internet and find some solution but still have one more question. so far I did following. create a form (frmCriteria), with list box link to table, in query criteria I added the [Forms]![frmCriteria]![List12]...