2,667 reputation
512
bio website scottmcclenning.blogspot.com
location Oxnard, CA
age 39
visits member for 3 years, 4 months
seen 2 days ago
stats profile views 180

Oct
5
comment Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Correct NOT would exclude Friday vice include Friday. Sometimes when working with compound statements you would need to change the ANDs to AND NOT.
Oct
5
revised Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Fixed Friday criteria.
Oct
5
revised Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Error in previous Friday code.; deleted 60 characters in body
Oct
5
comment Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
I updated my answer to include criteria for the previous Friday. I wasn't clear if you wanted to include the current Friday or not, so I put both criteria down. Hope this helps.
Oct
5
revised Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Added previous Friday criteria.; added 6 characters in body
Oct
4
comment Whole-disc encryption offer protection when using files?
Good point about there are attacks on full disk encryption. I agree it is key is retaining control of the system. If you lose control of the computer all bets are off. Also, I've heard of countries having cameras in the motel rooms usually over desks so they could see the keystrokes you type. So they don't even have to do anything hackery, just old school shoulder surfing.
Oct
3
answered Whole-disc encryption offer protection when using files?
Oct
3
answered How to execute a scheduled task with “schtasks” without opening a new command line window?
Oct
3
comment How to play an encrypted AVI file
Is that a real VLC message or something on the video? I agree with the comments about malware. If I had the guts to run it, it would be in a VM or junk isolated machine.
Oct
3
revised Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Forgot PM on time.
Oct
3
revised Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
criteria examples
Oct
3
comment Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
Also, the criteria keywords have changed little for the common functions, an old Access 2000/2003 book would be pretty relevant for newer versions of Access.
Oct
3
comment Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
The two ways I learned Access queries was by pressing F1 (which in 2010 is of no real help, unlike in 2000 or 2003), and using the Expression Builder. (in 2010 it is under Query Tools Design tab, Query Setup section, Builder). In the Expression Builder under Functions, Built-in Functions will be the keywords and usages. Clicking on the usage will pull up a help screen with examples at the bottom. I will have to research some sites, usually I would Google the keyword for additional help, but I'm sure there must be tutorial sites out there. If I find some I will post it.
Oct
3
comment FreeNAS: single-disk ZFS?
Glad it worked out and good call about making a RAIDz from the start.
Oct
2
comment Change Windows 7 Product Key
I've been in similar situations, usually it is a service pack difference, but I've had problems with retail & OEM versions not working with the other keys. There is something you may be able to do, but I would do an image first. Running sysprep should wipe out the system unique information but I don't know if that will let the new key work.
Oct
2
revised Finding all shortcuts to a file/application
added TextCrawler
Oct
2
answered Windows 7 share drive is mounted and can cd into it from ubuntu but cannot ls,cp,mkdir,etc
Oct
2
comment Query in MS Access 2010: “patient date admitted within the last 24 hours”, what is the criteria for this?
+1, good point. Sometimes computer people can be too literal. :)
Oct
2
answered how to count a congestion in a node?
Oct
2
answered Finding all shortcuts to a file/application