Recent content by samirshah172

Thanks, Its worked, :cool: Regards Samir

Yes it has key "LoadingNo" which is Auto number. let me try adding it. will submit soon.

Do is unique key. Table1 has Do, DoQty field. Table2 has LoadingNo, Do, Loaded field. Where LoadingNo is a key in table2. Thanks for the reply

Hello Forum, Example of My Query Which Shows Loading Detail Against tblDO from tblLoading: Do : Qty : Loaded 1 : 48.000 : 15.900 1 : 48.000 : 16.200 1 : 48.000 : 15.900 2 : 32.000 : I Need a Column Which Writes Balance of Each DO Do : Qty...

Ok Arnelgp, Its Worked perfect as required. thanks all

For each userID, The First(Lowest Time of a day) entry is IN & Last is Out of each day. Other entry will be ignored of a same user.

Thanks Arnelgp, I am getting error "ORDER BY Clause (tblDateTime.UserID) conflicts with UserID" my DB is attached

Thanks Minty for prompt reply, I have never used total Query but I will try and update. The field name i mentioned is not actual field name. Thanks Regards Samir

Hello Forum, I am trying to make a query Which Shows each persons in & out time of a same date, out of Several Entries of each user. I have a table1 With Fields UserID, DateTime Which Contain data as per below: UserID DateTime 1 13/09/2015 17:55:25 1 14/09/2015...

Thanks, Work perfect.

Hello Forum, In table1, "tblCompany" I have stored All Customers, Suppliers, Service Provider, Transporter etc. Fields are, CompanyID, CompanyName, ...... etc. In Table2, "tblSaudaBook" i am storing transaction by Fields, S_Num, S_Date, SupplierID(From tbl 1), CustomerID(From tbl 1)...

Cool, thanks for alternate suggestion.

Ok thanks:)

Ok got it, can you help me to populate DayName in report. Thanks for the help.

Hello, I am very new with access database. Want to create table with Dates & DayName. For example, tblYear2015 with all dates from 1-Jan-2015 to 31-Dec-2015 in FirstColumn and DayName in second column as per date of First Column. DayName Should be entered automatically as per date entered in...