Search results

Don't get this bit? :confused:

I think this is about right. =DCount("[CLASSIFICATION]","table name","[CLASSIFICATION] = Preliminary' And (Not IsNull([PROD1]) Or Not IsNull([PROD2]) Or Not IsNull([PROD3])")

What is the table structure? I'm trying to picture how you're storing the callback info. I would guess a query that asks for all names where there is a callback date and where the callback date isn't in the list of all calls made for that same person?

That way of thinking is probably what excludes you from becoming one. ;)

I remember an episode of a sitcom some years ago, where the main characters were talking and you could hear the TV in the background. It was set in the future and the guy on screen was saying someting along the lines of "...the discovery of a new page for the Bible has caused controversy...

Thanks for that. If you want to name a couple, I may give them a look. The only time I really get to just sit and read is on the train, but I find I can get through a book a week that way. I'm alternating between fiction/easy reading and titles I may learn something from (keeps my brain from...

If you don't want a total (i.e. all cell values added together), you could use DCount, rather than DSum e.g. =DCount("CLASSIFICATION]","table name","([CLASSIFICATION]='Preliminary' And ([PROD1]='?' Or [PROD2]='?' Or [PROD3]='?'")) This counts the number of Classification values for all...

Yes, liked that one. :D

Formal study? Very little, to be honest. Casual reading? A bit, on and off. What articles/books etc. I have read suggest that non-believers have one set of ideas about it's origins and accuracy, religious people have an entirely different set. Since I fall into the former category, I've probably...

Try putting quotes around [Barcode].

Thanks, both (it's much more reassuring to hear about personal use than just reading the product reviews). I'll look into all three and get something sorted out.

Given that the majority of the posters in the Watercooler tend to be - from what I've seen - American, Canadian, British and Australian, Americans would be perfectly entitled to say it as would the other three. :confused:

Do you mean after or before update? I only ask as it's safer to stop the record being inserted than to delete it afterwards. Either way, you can use DCount() for that record in the relevant table. If it returns more than zero, you've got a duplicate.

This part: Do you mean the things you have in your life (e.g. health, possessions, luck) could be viewed as hallucinations, the person/thing that provided them (e.g. God) could be viewed as an hallucination, or the means by which they were provided (e.g. a dream) could be viewed as hallucinatory?

So, have you always explained it as God's actions or did that come later in life? Isn't there at least one 'branch' (for want of a better word) of Christianity that believes what happens to you is pre-ordained, so it makes no difference if you're good or bad? Or does that pre-ordination just...

Well, that pretty much ends the debate in a disappointing way. Pity. Nobody expects anyone to be converted one way or the other but it was interesting hearing the reasoning behind people's thinking. "I know X to be true but I have no desire to convince anyone else of that fact. My knowledge is...

You can use the Replace() function to replace any occurrence with the full "Elizabeth". e.g. Loop through table For each record, Replace(name,"Elizh","Elizabeth") End loop If Elizh is anywhere, it gets replaced. f it doesn't exist in a record, nothing happens.

Are the fields Period and Year strings or dates? If the former, you need to put the criteria in single quotations, if the latter you need to use hash (or pound) signs. e.g. strQuery = "SELECT Workfile.Period, Workfile.Year FROM Workfile " & _ "GROUP BY Workfile.Period, Workfile.Year " & _...