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 (IMG:style_emoticons/default/smile.gif)

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

UtterAccess VIP
Posts: 8,140
From: CT
(IMG:style_emoticons/default/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

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: 8,140
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 (IMG:style_emoticons/default/smile.gif)

its working (IMG:style_emoticons/default/smile.gif)

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: 8,140
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
 
+
« Next Oldest · Access Reports · 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: 26th May 2013 - 01:43 AM