User Profile
emmapapa2
Copper Contributor
Joined Dec 09, 2021
User Widgets
Recent Discussions
Answer on access
I want to create the following Database in MS ACCESS named 'DB_HOTELS'. A hotel company has a number of hotels (hotel chain such as GRECOTEL etc.) decided to proceed with the construction of an information system. With this system, it aims to computerize the procedures related to its operation. For this purpose, a Database must be developed that will support the entire system with data. Information about the Guests / Customers of the hotel chain, Hotel Units should be used, for example, for GRECOTEL, the unit named "ATHENS GRECOTEL" has the number C10 and is located in the city "Athens", the Rooms of each hotel unit, the Reservations made in a specific unit and room by a specific Guest and for a specific date.600Views0likes3Comments- 3.1KViews0likes0Comments
- 1.2KViews0likes3Comments
- 3.4KViews0likes9Comments
SOS QUESTION EXCEL
Construction age (x5): The time period in which the date of issuance of the building permit is included is stated. In case of addition of a permit and / or inclusion in a law of arbitrary settlement, the declaration is made on the basis of the period of issuance of the initial building permit. In case there is no building permit, the construction declaration is made on the basis of being subject to an arbitrary settlement law. For the dates of issuance of a permit / construction based on a declaration of affiliation, the scoring is as follows: (x5≤09.08.1955) = 100 points, (10.08.1955≤ x5≤09.06.1975) = 80 points, (10.06.1975≤ x5≤31.12.1982) = 60 points, (01.01.1983≤ x5≤31.12.1992) = 45 points, (01.01.1993≤ x5≤31.12.2003) = 30 points, (01.01.2004≤ x5≤31.12.2011) = 15 points (x5> 1.1.2012) = 0 points The real problem is this! And I would like to introduce a functions tofind thw solution! Could you help me???830Views0likes2CommentsRe: QUESTION ABOUT EXCEL
Construction age (x5): The time period in which the date of issuance of the building permit is included is stated. In case of addition of a permit and / or inclusion in a law of arbitrary settlement, the declaration is made on the basis of the period of issuance of the initial building permit. In case there is no building permit, the construction declaration is made on the basis of being subject to an arbitrary settlement law. For the dates of issuance of a permit / construction based on a declaration of affiliation, the scoring is as follows: (x5≤09.08.1955) = 100 points, (10.08.1955≤ x5≤09.06.1975) = 80 points, (10.06.1975≤ x5≤31.12.1982) = 60 points, (01.01.1983≤ x5≤31.12.1992) = 45 points, (01.01.1993≤ x5≤31.12.2003) = 30 points, (01.01.2004≤ x5≤31.12.2011) = 15 points (x5> 1.1.2012) = 0 points The real problem is this! And I would like to introduce a functions tofind thw solution! Could you helpme???3.1KViews0likes13CommentsRe: QUESTION ABOUT EXCEL
For date from 1. <= 20/08/1950 to display the value 80 points and 2. for date> = 20/09/1950 until <= 30/10/1998 to display the value 60 points and 3. for date> = 31/10/1998 until <= 30/01/2008 to display the value 40 points Which way is the best to find the solution ?3.2KViews0likes3CommentsQUESTION ABOUT EXCEL
For date from> = 08/20/1950 to display the value 80 and for date> = 09/20/1950 to <= 10/30/1998 to display the value 60 and for date> = 10/31/1998 to and <= 01/30/2008 to display the value 60! I apply the datevalue command but I get something wrong! Could you help me ? Thank you very muchSolved5.3KViews0likes20Comments
Recent Blog Articles
No content to show