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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query Parameters, Office 2003    
 
   
Lorraine
post Feb 24 2012, 08:23 AM
Post #1

UtterAccess Veteran
Posts: 420
Hi there -

I have a form with three unbound textboxes and a command button. Textboxes - Begin Date, End Date and Employee #, Command Button - View Report.

The command button brings up Report A.

Report uses Query B. Query B has three paramenters:


[Forms]![1e-frmMedOrthoCompletePrompt]![txtMMID] - this is sending the EmployeeID from my form.

>=[Forms]![frmMedOrthoCompletePrompt]![txtBeginDate] And <=[Forms]![frmMedOrthoCompletePrompt]![txtEndDate] - this is sending the dates from my form

I also have one criteria in the query pulling all completed claims.

When I run the query and the report on its own and put in my parameters I get records. HOWEVER, when I put my parameters in my form the report returns no records.

Does anyone have idea what I could be doing?

Thanks Lorraine
Go to the top of the page
 
+
RAZMaddaz
post Feb 24 2012, 08:30 AM
Post #2

UtterAccess VIP
Posts: 6,322
From: Bethesda, MD USA
Is this a Select Query or a Crosstab?

Try the following to see if this works:

Like [Forms]![1e-frmMedOrthoCompletePrompt]![txtMMID]

Between [Forms]![frmMedOrthoCompletePrompt]![txtBeginDate] And [Forms]![frmMedOrthoCompletePrompt]![txtEndDate]
Go to the top of the page
 
+
Bob G
post Feb 24 2012, 08:33 AM
Post #3

UtterAccess VIP
Posts: 8,188
From: CT
what is the source of data for the report? the query ??
Go to the top of the page
 
+
Lorraine
post Feb 24 2012, 08:38 AM
Post #4

UtterAccess Veteran
Posts: 420
Hey there RAZMaddaz -

It is a select query and your recommendation worked!

U rock! Have a great day and thanks!

Lorraine
Go to the top of the page
 
+
RAZMaddaz
post Feb 24 2012, 08:45 AM
Post #5

UtterAccess VIP
Posts: 6,322
From: Bethesda, MD USA
Glad WE could help!!!!

RAZMaddaz
(IMG:style_emoticons/default/thumbup.gif)
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: 18th June 2013 - 12:40 AM