Search results
-
E
how to select data for calculation
CJ Something similar but have to lookup the price with the date I have two criteria to lookup a) Hotel b) date of stay i am new for Access formula. If i built a table, for hotel with different date price which , then, Reservation Form can calcualte the total room costs ? Table for room... -
E
how to select data for calculation
Dear Guru I have a question in selecting data for calculation I use that for hotel room calculation Date of stay 1/10 - price : 100 2/10 - price : 120 3/10 - price : 100 Now guest stay from 1- 4 Oct , so i need to calcalate the sum of price based on the period of their stay How can i do... -
E
Update the table
I try to do this but fail Select the excel file, append , but fail -
E
Update the table
i think that maybe complicated for me... I do not know coding, and i have set up all relationship, links, it bother me if the name of databased/table changed All went wrong, as have lot of queries and forms linked Eric -
E
Update the table
Minty I try to do change the ID in number rather than autonumber and use Append. But it prompts me with another error. Frustrated Eric -
E
Update the table
Dear all I have difficulty to update a table. Firstly, i imported excel file to Access,named Registration. After working for a while on around few days, on 1,300 record. There are update on the original excel file and i need to import again to the Registration. First i try to update those...