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

Welcome Guest ( Log In | Register )

> 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
 
+
 
 Start new topic
Replies
Bob G
post Mar 31 2012, 08:42 AM
Post #2

UtterAccess VIP
Posts: 8,106
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
 
+

Posts in this topic
- tiktik2x   Query In Report   Mar 31 2012, 08:01 AM
- - Bob G   what version of access are you using? you may want...   Mar 31 2012, 08:42 AM
- - tiktik2x   MS access 2007 what is the formula or sql that i ...   Mar 31 2012, 08:50 AM
- - Bob G   you can use the design view of the query. in the c...   Mar 31 2012, 08:55 AM
- - tiktik2x   Thank you very much Sir BOB its working how ab...   Mar 31 2012, 09:06 AM
- - Bob G   what do you mean by "in time"   Mar 31 2012, 12:12 PM
- - tiktik2x   i mean to search or make a query for time...   Mar 31 2012, 05:57 PM

« Next Oldest · Access Reports · Next Newest »
 

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

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 04:28 PM