Search results

No🤔 . i have tables . But there is no need to attach my tables and my question about one table If you want help me thats right If not l have no any problems

my question about one table. Why do you want me to attach my database? I dont want total hours. This is easy . I want to show detail idle hours for employee as shown in the attached picture?

This is not my homework. It is a new database that I want to design, but it is the first time I was faced with such a problem, and I did not find a solution to it and how to create its query.i have tried unmatched query but i failed😅

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

no problem, I searched all the forums and couldn't find anyone who looking into this case

Yes i think that. It is a croup of codes makes to easier for the users

It is a package A package is a collection of related modules that work together to provide certain functionality. These modules are contained within a folder and can be imported just like any other modules. This folder will often contain a special __init__ file that tells Python it’s a package...

the main problem is i am using telegram.ext library in python but i dont know What is the equivalent library in ms access if it exist!

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

I have quite a bit of knowledge of ms access but the main reason I didn't post is that my English is not perfect

This is a better design. Thanks

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?

I think this is the best solution for a large database Thank you very much(y)

Incorrect result query is working fine but a will try run it on a big data . Thanks

But when i change data in table gave me incorrect result see below I would like ro see your attempt but where your attachment?

(use pass throug query )Do you mean i run ms- Access as a front-end application and then link to tables in a back-end server, No i have already that .but i want run my database as local not as front end

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

The query is working fine. Thanks

Yes latest not last. Create...! I will try when the pc is available And add my comment Thank in advance

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