UtterAccess.com
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 laugh.gif
Go to the top of the page
 
+
Bob G
post Mar 31 2012, 08:42 AM
Post #2

UtterAccess VIP
Posts: 10,149
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


--------------------
New Year. New Knowledge.

Instructional Reading
Go to the top of the page
 
+
tiktik2x
post Mar 31 2012, 08:50 AM
Post #3

New Member
Posts: 7



MS access 2007

what 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,149
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]


--------------------
New Year. New Knowledge.

Instructional Reading
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 <

its 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,149
From: CT



what do you mean by "in time"


--------------------
New Year. New Knowledge.

Instructional Reading
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: 24th July 2014 - 09:36 AM