Recent content by RoarCRM

  1. R

    Query Results on a given date

    Won't let me post an image/attachment as I don't have 10 posts. Basically it's: Client -----< Service ------< Project------< Task The issue I'm having is that when I include Task in the query in order to try and search by task date it creates a new row in the query results for every task but...
  2. R

    Query Results on a given date

    Hello, I have a problem that I'm struggling with. In our database we have services, within services we have projects and within projects we have tasks. I want to display all projects that are currently 'Live' and show the results on a given date. So if I select 1 May 2014 I want only tasks...
  3. R

    Database Design Question

    Hello, I'm new here so apologies if this question is in the wrong place - feel free to shift it :) I am looking at designing an access database that needs to record details of all of our clients, jobs that we currently work on with them, and every session that we work on for each job. How...
Back
Top Bottom