Recent content by rnorthcott

  1. R

    More Advanced Query Assistance

    Thanks for your help so far. I feel like there is going to be more time and effort involved in obtaining the specific information they are looking for than they are going to want to invest, especially since the existing system meets 98% of their needs. I will discuss this with them further and...
  2. R

    More Advanced Query Assistance

    Each group member pays the fee. Start date of February 1st and end date of February 2nd is two days. The fee types are either seasonal or daily, so it would only be the daily types that would need the calculation performed. Hopefully that answers your questions.
  3. R

    More Advanced Query Assistance

    Thanks for the additional information and suggestions about subdatasheets and forms/sub forms. I will definitely put some thought into that. Here is the screenshot of the relationship window. Let me know if there is any additional information I can provide. Raymond
  4. R

    More Advanced Query Assistance

    Good morning, I'm looking for some assistance with a couple what I'm thinking are slightly more advanced queries for the registration database I'm working on for a client. Firstly, I have a table that tracks reservations made by visitors, which is linked to a table of information related to...
  5. R

    Order of table rows switch when added to a sub report

    adding a sort on the report data for the win. I knew it would be relatively simple. I had seen the group and sort options previously, but had to figure out the correct field to sort on and then ensure it is included in the data source. Thanks for the push in the right direction.
  6. R

    Order of table rows switch when added to a sub report

    Definitely some things to consider. Thanks for your input.
  7. R

    Order of table rows switch when added to a sub report

    Hello everyone! I am working on updating a reservation database that I created over 10 years ago and am running into a couple client requests I can't figure out. The bulk of the database focuses around entering group reservations for one of Canada's national parks. When saving the group...
  8. R

    A little about me (rnorthcott)

    Hello everyone! I hardly ever use Access but about 10 years ago I created an access database for one of Canada's national parks and have had to support it occasionally since, so my posts will focus on getting help with those support attempts. I live in Manitoba with my wife and 2 kids. I am a...
Back
Top Bottom