Search results

  1. A

    Select empty work hours of task

    I have a staff of employees working hours from 8:0 to 16:00 Each employee is given tasks, each task has a specific duration of one or two hours ..., and the employee may be given more than one task per day. I want to know which hours of the employees spend it without task As below
  2. A

    making telegram chatbot as python

    I have a telegram chatbot in python in this bot I can make it auto reply on users if users input limited words by give them Specific options for to choose one of them . my question is can I make it in Ms access database. I have already Ms access database it is sending pictures and messages...
  3. A

    Grouping report

    I have a salary table that has four levels for an employee's workplace Any employee may have two , three or four levels for determine his workplace. I made a report to know the sum of each of the four levels, But it design is not good I want to be the report like this Any help?
  4. A

    Get recursion field as sql server

    I have a table on sql server As shown in the picture and when run this sql statement with cte as (select h1.empid, h1.parentid, h1.employee_name [recursion], employee_name [employee name], cast(h1.id as varchar...
  5. A

    get to Last price for each product and each suppliers

    I have trans table contains Productid, price, date, supplerid feilds How can i get last price for each item and each suppliers as in picture i have same database on sql server and i got help. The sql statement works perfectly as bellow select max(date) as date, productid, max(qty) as...
  6. A

    fifo method and cost

    hello I provide you with a database to calculate inventory by fifo method and calculate the cost of materials in sales invoices The pre-existing database (fifostock) was used for modification. ms access 2007 and apove
  7. A

    Control of warehouses and sales* men

    this project is On the basis of considering A salesperson's distribution vehicle to be treated as a warehouses
  8. A

    the main form doesn't work when compressed by zip-drive

    hello every bod I wanted to add a sample databas but I ran into a problem the main form[user] doesn't work when compressed by zip-drive but its works fine with rar-drive or unzipped it can any one help me to solve it and add it in sample database and Explain the purpose of this database
  9. A

    Bank cheques managment sample by access2007

    hello here is aContribution of me to support samples Bank cheques managment sample by access 2007
  10. A

    Aging receivable

    _hello This is the first post for me I have a database for the Aging receivables The problem is:When I make run "Qage"query that calculates Aging receivables depends on "id" field "Gltrans"table look in " Q1" query but I want calculates Aging receivables depends on "Opdate" The...
Top Bottom