Search results

  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...
Back
Top Bottom