UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Microsoft Access Project Help Needed!    
 
   
Carly
post Oct 20 2005, 09:11 AM
Post #1

UtterAccess Addict
Posts: 134
From: Hull, E.Yorkshire
I am using Microsoft Access Project and I have never used it before so please forgive me if this is a stupid question...

I have created a View which groups by date and then counts the number of lines entered for those dates. What I would like to do is restrict the dates to dates entered into a text box on a form. Just like I would in Microsoft Access (i.e. BETWEEN Forms!Frontpage!txtDate1 AND Forms!Frontpage!txtDate2).

The SQL to create the view is as follows:
CODE
SELECT     TOP 100 PERCENT CONVERT(char(11), wcs_entry_date_time, 103) AS Date, COUNT(wcs_container_id) AS [Number of Units Received]
FROM         dbo.wcs_mhejrn_stock_received
GROUP BY CONVERT(char(11), wcs_entry_date_time, 103), DAY(wcs_entry_date_time), MONTH(wcs_entry_date_time), YEAR(wcs_entry_date_time)
ORDER BY MONTH(wcs_entry_date_time), DAY(wcs_entry_date_time), YEAR(wcs_entry_date_time)

Is there anyway in which this can be done?

Kind Regards

Carly
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 07:17 PM