Recent content by Xabu

  1. X

    Looking up valuse

    I have a table where I keep data for multiple hotels where I hae the following rows - Year - month - country of origin - nationality criteria - this field has only 2 options, "f" for foreign and "d" for domestic - hotel - number of guests - number of nightings I made a query that returns all...
  2. X

    updating spreadsheets and/or pivot tables

    Thanks ... you solved more than one problem I had :)
  3. X

    updating spreadsheets and/or pivot tables

    I'm new with this. I'm interested dow can I add spreadsheets to my reports, I need to show the data from my database in the form of spreadsheets or pivot tables. If that is possible at all. For example, I have a database that keeps track of how many guests of what nationality spent time in...
  4. X

    Query - weird decimals return

    I enter values into a table with 2 decimal places. I have a query that applies percents to the values - I have set the results to have 2 decimal places. I have another query that summarises data from the previous query, however the results I get are not right, the decimals differ from the...
  5. X

    Assets database query

    I am building a simple assets database to help me with my work. This is what I did: I created a table with following columns: 1) Bill ID - unique number of the asset bill, created by the accounting software. 2) ID of the supplier 3) Month 4) Type of the bill (code such as RI for...
Top Bottom