Recent content by galinda13

Thanks for this - will take a look.

Hello, I work for a telephone company and am producing a database to help us with our monthly billing. We get a CSV file from our supplier each month with a list of calls made by our customers - including the date/time, phone number the call was made from and to, the duration in seconds and the...

That gave an error about only being able to return 1 record from a subset - however it got me started and I just set up a query showing only open tasks, and then drew the data from that. Thanks for your help :)

Thanks for the reply! The tasks have the following fields: TASK_ID - Autonumber unique to each task TASK_PROJECT - Integer, number of the project this relates to TASK_TYPE - Integer, type of task this is TASK_NAME - Name of the task TASK_STAGE - Integer, what stage of the project is this task...

Hello there, I've been scratching my head with this for a few hours now and I'm sure I'm missing something obvious! I have two tables - one is PROJECTS and the other is TASKS. PROJECTS contains a list of projects currently to be undertaken by the department. TASKS contains a list of tasks...