Search results

Dear Forum, I have the following fields in an access query and I expected the calculated field HoursUsedOnContract to display the value of 2.75, but it is giving 0 instead. Please can you advise what I could be doing wrong? OpenedTime = 31/08/2018 15:28:53 ContractStart = 01/09/2017 ContractEnd...

Dear Forum I am running an Access database that works like a timesheet system. It is split in to a front end and back end and the front end is used by about 15 users who each have a copy of the front end on their PC. The back end sits on the server. One of the users had an issue with their...

Dear Forum I am creating a simple timesheet database (see attached form layout) And wanted help to get the table design right. i was thinking this would require 3 tables AdvisorName Week TimeSheet I was thinking that AdvisorName would link to Week with 1-M and that week would have a compound...

Dear Forum, I have a table that is part of a wider database. The table includes the following fields: AdvisorName * (Text) TimeLogID* (auto number) ProjectID (number) LogDate (date field) TimeForecast (number field) The compound primary key field is indicated with a *. The other fields...

Hello, I have a concatenate query that is run using a module given further below, which on its own works OK When I relate the concatenate query to a related table in a new query or add additional fields to it, it runs OK for a short while, but when I scroll up and down through the data, I then...

Hello, I have a simple sales database in Access 2013 with various date fields I need to produce queries and reports using week numbers When I use Format([DateField],"ww") Access gives me week numbers that are 1 week ahead of my business calendar week numbers, and they don't match up. I...

Hello This is probably a silly question. I have a simple database with a one to many relationship between 'Consumer' and 'Products'. One consumer has many products. Some consumers consume chocolate OR some consume cola, and some chocolate AND cola I want to run a query that gives me only the...

Dear All I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products) My client needs to routinely send me lists of tests and the products that are in each test. I then...

Dear Forum, I want to create a small relational database in Access 2013 and then publish it on to sharepoint. I want to be able to set up table relationships and design my forms etc I found an article that explained how to build and publish to sharepoint using blank web database template in...

Dear Forum, I am creating a database that has the following tables linked with a one to many relationship. one PROJECT to many TESTS. So, each project has many tests I want each test to be numbered in such a way that it indicates which project it is from....e.g. Project ABC: tests...

Dear Forum, I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS Is my design reasonably sensible? Would you...

Dear Forum I am very pleased to join up. I am a strong advocate of using Access in our department but am a little alone in this regard - but think it really helps organize what we do I really like working on Access but am largely self taught and so need to know lots more to get the most out...