Search results

Well, your results are what I get ...: SELECT offmin=m.tmpmin, offmax=m.tmpmax FROM(Select t.year_ID,t.mnth_ID,t.day_ID,tmpmin=min(t.l), tmpmax=max(t.l) FROM( select n.year_ID,n.mnth_ID,n.day_ID,l=n.load_1 FROM temp n UNION ALL SELECT n.year_ID,n.mnth_ID,n.day_ID,l=n.load_2 FROM temp n UNION...

He's not listening (reading ...)

The GUID is not really designed to be something that is utilized as an OrderID or anything like that. It ensures uniqueness for dislocated data entry. I don't think it even displays in later versions of Access. I would use some other convention for the order ID. Perhaps concatonate an...

Psuedocode: global variable LastUpd (set on the Open event) global variable AOne If (AOne = Range("A1").value AND TIMER - LastUpd > (10 minutes * 60 seconds)) OR (If IsNumeric(Target.Value) And Target.Value > 7000) THEN Mail_CDO AOne = Range("A1").value If target = A1 then LastUpd = TIMER

*** To add a quick comment, OrderID is an Integer. A Replication ID is a Globally Unique Identifier (GUID).

Why are you changing it to Replication ID? Do you know what a Replication ID is? It is really to be utilized when using a Merge replication and you have remote instances synching up with a master. If this is not your utilization, what is your goal?

I am going to assume you are asking how to get the first 5 characters and the last 4 characters of the zip (if they exist). There are easier solutions, but without knowing what the data type is ... SELECT LEFT([CLIENT TABLE].ZIP,5) as FirstFive, IIF(LEN(RTRIM([CLIENT TABLE].ZIP)) > 7...

I believe you have 4 different options available to you under conditional formatting ... Use the 3 conditions for 3 of the values and the Default Formatting for the 4th value ...

Here is the code I use for Table Audits. It works pretty flawlessly: CREATE TRIGGER trg_tblName_Audit -- Change this name accordingly reflective of your trigger ------------------------------------------------------------------------------------------------------------ --& --& Name...

Only way I can think of is to have a job that runs, say, every minute that truncates and populates a table that Access queries.

MsLady, you just have to do it. On your own. Create a website on your home network for your own address book. Keep building it, adding more functionality and cooler graphics/flash stuff as you investigate, learn and apply your new found knowledge. I have found that is what works best for...

Try: wo: Count(CallID)*100000)/[Area]

I'm with you there, brother!!! I like the way you think.

Yeah, I do too. It is the reason Accessman2 has red jello (reputation). He doesn't play nice. :D

aj, that is my point exactly. What many Access programmers don't think about is the TOTAL cost of implementation. They run a complex query that returns their results in 15 seconds and say, "Hey, that was fast. Great, we'll go with it." But they don't realize that they have locked several...

It will ... there is something else going on here, but Accessman2 never follows up with the results of what he gleans from here. :(

Hmmm ... faster or better ... if the clerk is smokin' hot, I'd probably opt to take my roll in. My point is, just because it is faster the one time you run it, doesn't necessarily mean it is overall the best solution. My case in point would be utilizing those d@mn Domain Aggregate functions...

Try ... strSQL = strSQL + " Between #" & [StartDate] & "# And #" & [EndDate] & "#"

This works fine: use Northwind GO Create View NorthTemp AS SELECT e.LastName, [Check] = CASE WHEN e.Region = 'WA' THEN 'T' ELSE 'Exe' END FROM northwind.dbo.Employees e GO select * from northwind.dbo.NorthTemp GO drop view NorthTemp

This is a report issue, not a query. You are looking to have the data grouped physically on a report, not grouped for aggregate reasons. Look at Sorting and Grouping in reports. That is what you are looking for, I'm guessing.