Recent content by carlisle

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...

There ya go! Cheers once again...

No, when I replace the previous date part with that expression it comes up with a syntax error? Thanks for the attemp tho.

Need some more help lol. Um, the date hasn't been automatically updated, so it's showing the records from yesterday, the 7th. Because of '#09/07/2006#'?

Excellent! I didn't know about that SQL view. Thanks for the mentoring lol

"[B]The syntax of the subquery in this expression is incorrect/[B] Check the subquery's syntax and enclose the subquery in paretheses" And, YES, I have changed the names! ;) lol Also, which field should I put the expression in? :D

That seems to be what I want, but it comes up eith syntax errror for some reason?

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

Thanks, I'll give it ago and see what happens, hopfully I won't need to reply to this again... ;)

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...