PC Review


Reply
Thread Tools Rate Thread

adding another control

 
 
TheDrescher
Guest
Posts: n/a
 
      17th May 2010
I'm currently running a report to pull retention data for a certain time
period in my database. The current code I use is:
Dim strWhere As String
Dim stDocName As String
stDocName = "RetentionReport"
strWhere = "[Date] >= #" & _
Forms!CountsReportMenu![FromDate] & "# And [Date] <=#" & _
Forms!CountsReportMenu![ToDate] & "# "

DoCmd.OpenReport stDocName, acPreview, , strWhere

In addition to the date range I'd like to add a line that says to only pull
records where the RetentionEffort field = Yes. Is there a way to add this in
without me messing up my date coding? Thanks!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Exception: A circular control reference has been made, when adding control to form Kevin Spencer Microsoft Dot NET Framework Forms 4 16th Nov 2007 11:17 AM
Re: Exception: A circular control reference has been made, when adding control to form Marc Gravell Microsoft C# .NET 1 15th Nov 2007 08:12 AM
Re: Exception: A circular control reference has been made, when adding control to form Mikus Sleiners Microsoft Dot NET Framework Forms 0 15th Nov 2007 08:02 AM
adding runat=server to a control on aspx page, don't cause the IDE to add the control to the code behind z. f. Microsoft ASP .NET 1 25th Jun 2004 04:15 AM
Re: adding runat=server to a control on aspx page, don't cause the IDE to add the control to the code behind Phil Winstanley [Microsoft MVP ASP.NET] Microsoft ASP .NET 0 24th Jun 2004 01:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:16 AM.