<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Database Lessons</title>
	<link>http://databaselessons.com/blog</link>
	<description>Tips for MS Access users</description>
	<lastBuildDate>Tue, 19 Jul 2011 11:48:55 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>IF Statements In A Query</title>
		<description><![CDATA[Question: In a query with 2 columns based on 2 fields in a table, how can I create a 3rd column that lists the minimum of the other 2 columns? Answer: Here is a simple list of sample data for this query. Field1 Field2 Smallest ---------------------------------- 5 7 5 9 3 3 8 7 7 [...]]]></description>
		<link>http://databaselessons.com/blog/if-statements-in-a-query/</link>
			</item>
	<item>
		<title>Cascading Queries in a Single Query</title>
		<description><![CDATA[As promised, here is the query within a query solution that simplifies the last article&#8217;s idea. We saw in my last post how a question like &#8220;Who was the first person to borrow a book?&#8221; could be solved by having a query use the results from another query. That required 2 actual queries saved separately. [...]]]></description>
		<link>http://databaselessons.com/blog/cascading-queries-in-a-single-query/</link>
			</item>
	<item>
		<title>Query On Query</title>
		<description><![CDATA[Some of my Access Database using readers may not know that a query can use another query for its source. Many of us get into the mindset that a query only reads from a table. So, if I create a new query and choose Design View, the next screen that pops up is called the [...]]]></description>
		<link>http://databaselessons.com/blog/query-on-query/</link>
			</item>
	<item>
		<title>Simple Report With SubTotals and Grand Totals</title>
		<description><![CDATA[Someone read the post from 2 days ago and took this to a slightly further point. How can I list all the details, and also list subtotals by a subset of the itemID, and then a grand total. They were referring specifically to a report of the data. Here is some fake data I created [...]]]></description>
		<link>http://databaselessons.com/blog/simple-report-with-subtotals-and-grand-totals/</link>
			</item>
	<item>
		<title>How To Do Group By Queries On Groups</title>
		<description><![CDATA[I know. Lousy title. Could not dream anything better up at 5:30 am on a Monday morning! A reader wrote in to ask why they could not get their MS Access summary query working. They wanted a report like this. Group Budget Actual 01 $ 34,000 $ 33,756 02 $ 75,000 $ 69,955 03 $ [...]]]></description>
		<link>http://databaselessons.com/blog/how-to-do-group-by-queries-on-groups/</link>
			</item>
</channel>
</rss>

