So how does this handle a TRAVELDATE with a time stamp on it? For example, what if there were 2 TRAVELDATES = 01/22/2014, but with different time stamps? I assume both would be displayed. I really just want only one of those to appear, and it can be an average of the two.

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

The DB is way too large to send. The issue is that the suggested code shown below does not return unique instances of [PLACECODE, PLACE, TRAVELDATE]. In other words, the query returns more than one row with [PLACECODE = 125, PLACE = "California", and TRAVELDATE = 01/22/2014], when it should return that combination only once.

No need to send entire DB. What are the results of the following query?
select top 25 id, placecode, place, traveldate, city, traveltime, qualify
from yourtable
where city = 'Seattle'
and placecode = 125
and place = 'Califormia'
and traveldate = 01/22/2014

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…

In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…