I have a dialog form that pops up to retrieve dates for a report. The form works and then takes the dates and generates the query based off of those dates just fine. However, the query only outputs a single Total and therefore the dates are in a subquery. I want the report to say on it which...
I have a dialog form that pops up to retrieve dates for a report. The form works and then takes the dates and generates the query based off of those dates just fine. However, the query only outputs a single Total and therefore the dates are in a subquery. I want the report to say on it which...
I built a query to take totalcount of distinct cardnumbers of individuals accessing a datacenter. The code looks like so:
SELECT Count(EntryData_2008_02_to_04.CardNumber) AS TotalCount
FROM [Select DISTINCT EntryData_2008_02_to_04.CardNumber, EntryData_2008_02_to_04.EntryDate FROM...
I am trying to build a form for the user to pick date constraints. The form has two text boxes, one called txtStartDate1 and txtEndDate1. Below the two text boxes there are four command buttons. The first command button is labeled today and if pressed populates today's date in the text boxes...
I am trying to build a form for the user to pick date constraints. The form has two text boxes, one called txtStartDate1 and txtEndDate1. Below the two text boxes there are four command buttons. The first command button is labeled today and if pressed populates today's date in the text boxes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.