Search results

I'm trying to get my head round this query and not having much luck. I have table that contains. amongst others, two fields I need to use - Date and Amount. I already have a query that returns me the number of entries for a given month, along with the total value. SELECT Count(*) AS [Number of...

Or, indeed, bread and circuses? Hasn't that been tried, without success? Distractions are no long term solution. People busy trying 'to make ends meet' don't necessarily so so quietly. If someone can see that somebody else is better off - and there's always someone better off - resentment is...

Isn't that because he's off skiing somewhere? :confused:

This may help you http://www.access-programmers.co.uk/forums/showthread.php?t=117044&highlight=postcode+format

Put 'DoCmd.Maximize' in the form's On Open event. You can also use the 'SetFocus' function here to move focus to whichever control you want. You can set the overall tab order for the form by opening the form in design view and going to View - Tab Order.

Very. You're going to fit right in. :D

I think something like this should do it. Select [Address], [City], [Zip] From [Employee Address], [City Zip] Where [Employee Address].[City] = [City Zip].[City] AND [Employee Address].[Zip] <> [City Zip].[Zip]; Hope it helps.

I don't know enough about specific cases to comment, so you may have a point. I know there are differences. The problem with mandatory sentencing is that - if it isn't a spur of the moment crime of passion - the offender will automatically know the risk involved in advance. For example...

I should have included this on my last post. I don't say that the UK system is ideal - far from it - just fairly consistent in application.

I can't speak for anyone else, but I taught myself by working out exactly what I wanted to do in English, then searching for keywords (validation, enable, visible, etc.), on this forum and other places. At the risk of sounding like I'm trying to avoid helping, I found I learned the most by...

Doesn't the US system vary from state to state? I know there are many consistencies and that many laws are the same from one place to another, but the punishment meted out definitely suggests a different attitude toward criminals in different parts of the country. How many states still have the...

The only problem I could see with this is that once someone is in prison, they hardly suffer as we might like them to. They lose their freedom, true, but they're cared for, fed, clothed, educated (if they so wish), etc. all at the taxpayers' expense (to use a cliche). I agree that once someone...

They certainly seem to. That and the 'Wait XXX minutes' one posted by KalelGmoon.

In the AfterUpdate event of the 'Damage to Property' field, you could add code along the lines of If [Forms]![form name]![Damage to Property] = True Then [Forms]![form name]![Damage Contents].Enabled = True Else [Forms]![form name]![Damage Contents].Enabled = False End If This...

You don't need to compare the hours and minutes separately. I think this should do it. IIf(Format([Request date], "HH:MM") > #12:30:00 PM#, "After 12:30", "Before 12:30")

I'd go along with this idea. Perhaps not the amputation bit - because it then falls to the state to look after the people who've been mutilated (I had the same conversation back in Uni, when I suggested that paedophiles should be crippled) - but automatic jail time, definitely. It wouldn't work...

I think it was here? http://www.access-programmers.co.uk/forums/showthread.php?t=99199&highlight=%22capital+punishment%22