Search results

Appreciate you, brilliant guys! Thank you for your time. Your comments helped me. I am going to create a table to store these values and use query. Thank you again for your time.

I added an Access file with a temporary table and code. Please help.

Thanks everyone for replying. The sort_order table is used only when there are duplicate member_credits. It will apply to only those members.

How do I sort the values in descending order? Also, if two or more values are duplicates, the order depends on another table. The table below is not saved in the database. The VBA code calculates and brings values for the member_credits column for each member ID. member_id member_credits 1...

I appreciate June7 and The_Doc_Man. Thank you. I am not in the right direction.

How do I combine multiple 1D arrays and create a table (rows, columns) like a 2D array using a loop? Public Function GetCombineArray() As Variant Dim ColA() As Variant, Row1() As Variant, Row2() As Variant, Row3() As Variant Dim NewTable() As Variant, RowInputs() As Variant Dim iC As Integer...

SELECT emp_clock.emp_no, emp_clock.emp_dept, emp_clock.clin_date, emp_clock.clin_time, dept_shift_times.work_days.Value, dept_shift_times.shift_type, IIf((Format([emp_clock].[clin_time],"Short Time")<=Format([dept_shift_times].[clin_to_time],"Short Time")),"On time","Late") AS Attendance...

Three tables for the clock-in application at the hotel. emp_clock has employees clock in and clock out information. dept_mast is the master department with the primary key. It has departments like Breakfast, Housekeeping, Laundry, etc. dept_shift_times has all departments and their ideal...

sorry for being late. so solution is to make subform continues instead of datasheet thanks

I have database for housekeeping for hotel. Main table: tbl_hkeeping_Mast date houkeeping_no (primary key) housekeeper_No child table: Tbl_hkeeping_Detail housekeeping_no (ref. key) room_no (combo box on datasheet subform) room_status service in a subform, I have room_no as combobox, which...