Search results

Hi, I'm trying to create a count on a tick box of products that have been reviewed, however, the SQL statment I am using (as I have for a couple of other counts will not work fo this dues to 'Data type mismatch' which I can only presume is due to the fact that is is a tick box.... SELECT COUNT...

Hi, I need to work out a couple of calculations, the number of days between an engineer starting and finishing a project, the number of days between the project being put on the database in the first place and being completed by an engineer and finally, the difference between these. These maybe...

Hi, Not sure where to put this, but as I want the information to be shown in form view, I guess this is the bext place to start. In breif, I have created a database, in which infomation on machinery is held. The problem I am having (atm), is I have to create a function, which I want to be...

Hi, I have a database, in which I need to add up the total number of entries made at any point of the day. I have started by creating a query with the entry's SerialID (unique) and the date it was entered, however I am stuck already. Any help would be appreciated, Ben

Hi, I am creating a database where the serialID can be a number of different 'formats'. TBH, I don't know if this can even be done in the first place, but on the off chance that it can....:p Firstly, i'm not sure whether to use Input Mask or Format... But the serial may be '1234567AB'...

Hi, I'm new to this site, so hello. I am currently creating a database for the company I work for, and having alot of problems as I go. At the moment, I am stuck with a form problem. I have created a number of search Querys (using [Enter SerialID] ect. into Criteria). I have then created a...