One of the experts helped me with an SQL query a couple of weeks ago. Here is the result which works fine...
SELECT a.reason1, Count(a.reason1) AS CountOfreason1
FROM (select reason1 from tblJobsToAnalyzeFromSQLview
select reason2 from tblJobsToAnalyzeFromSQLview
select reason3 from tblJobsToAnalyzeFromSQLview
select reason4 from tblJobsToAnalyzeFromSQLview
) AS a
GROUP BY a.reason1
But now I need to add a date range criteria somehow and don't know how to code it. The form I'm using has two date type text boxes... txtStart and txtEnd. The table is tblJobsToAnalyzeFromSQLview and the field the date range criteria has to work against is "LastInvoice".
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management.
Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…