Search results

  1. S

    Query to Find Balance

    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...
  2. S

    In & Out Time Query

    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...
  3. S

    Many to many Table design

    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)...
  4. S

    Table with dates and dayname

    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...
  5. S

    hello Forum

    Hello Forum, I am Samir Shah from Mumbai, India. I am very much new to Access. having few knowledge of excel vba. Warm regards Samir
Back
Top Bottom