UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Query In Report    
 
   
tiktik2x
post Mar 31 2012, 08:01 AM
Post #1

New Member
Posts: 7



good day everyone <
I have a question is it possible to search on report using a parameter?
for example i have a fieldname DAY and having a value of MONDAY to SATURDAY
then what if i open the report and the parameter pops-up and i enter the MONDAY
all the values that having a value of MONDAY will appear
is it possible?
THANKS IN ADVANCE
Go to the top of the page
 
+
Bob G
post Mar 31 2012, 08:42 AM
Post #2

UtterAccess VIP
Posts: 10,332
From: CT



welcome2UA.gif
what version of access are you using?
you may want to search UA for reserved words jut to avoid issues going forward
If you have a query where you prompt the user to enter the day, and then base the report off of that, then the report will ask for the date as well
Go to the top of the page
 
+
tiktik2x
post Mar 31 2012, 08:50 AM
Post #3

New Member
Posts: 7



MS access 2007
That is the formula or sql that i going to type in the criteria any idea sir?
THANKS for the reply
Go to the top of the page
 
+
Bob G
post Mar 31 2012, 08:55 AM
Post #4

UtterAccess VIP
Posts: 10,332
From: CT



you can use the design view of the query. in the criteria of your day field put int something like this. include the brackets
Please Enter Day Of Week]
Go to the top of the page
 
+
tiktik2x
post Mar 31 2012, 09:06 AM
Post #5

New Member
Posts: 7



Thank you very much Sir BOB <
ts working <
how about in time? it is posible in time?
Go to the top of the page
 
+
Bob G
post Mar 31 2012, 12:12 PM
Post #6

UtterAccess VIP
Posts: 10,332
From: CT



what do you mean by "in time"
Go to the top of the page
 
+
tiktik2x
post Mar 31 2012, 05:57 PM
Post #7

New Member
Posts: 7



i mean to search or make a query for time...
Go to the top of the page
 
+

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

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 30th August 2014 - 09:22 AM