Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old December 12th, 2003, 07:59 AM
Tmole99 Tmole99 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Location: West Yorkshire
Posts: 8 Tmole99 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Query entry in report

This may be simple but I can't figure it out

I use a simple query called week number in which you enter the week number.

This is via the queries criteria box like [enter week number]

If I enter say 41 here to show week 41, how do I get this number entered onto the report itself ? like a heading called "Week 41"

Can I take the value netered into the query and display it on the report ?

Thanks for any help

Reply With Quote
  #2  
Old December 12th, 2003, 10:49 AM
sbaxter sbaxter is offline
Moderator: Access, SQL
ASP Free God (5000 - 5499 posts)
 
Join Date: Oct 2003
Posts: 5,126 sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
Ar first I though I know exactly what you should do, and as I start creating the query to pull a single week for data, I thinking to myself, you already the the data you need to enter in the report header which week's of data you are pulling in.

TO you question

Can I take the value netered into the query and display it on the report ?
YES

Whe you enter the criteria of 41 the same column will only list 41 so just pull from that field and put it into your report header.

But if you every want to do a week range (41-45) here is sql code for that

SELECT Table1.CurrDate, Format([CurrDate],"ww") AS Week, [Enter the Beg Week] AS BegWeek, [ Enter End Week] AS EndWeek
FROM Table1
WHERE (((Format([CurrDate],"ww")) Between [Enter the Beg Week] And [ Enter End Week]));

s-

Reply With Quote
  #3  
Old December 15th, 2003, 02:14 PM
Ling Ling is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 24 Ling User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 3 m 7 sec
Reputation Power: 0
query entry in report

Not sure if this will help you, but here goes...

Assuming your query asks for parameter entry to run the report for, if you simply want to print the parameter(s) entered, try this:

In design view of course, in the Page Header (Not the report header, unless you only want headers on the 1st page), insert a Text box where you want it.
In the Control Source property for the text box, enter the same exact parameter that you have in your query, for example [Enter Beginning Date:]
The label for the text box can say something like "Report Run Date" or whatever your parameter is asking for.

Another way you can do this is if you are passing parameters to a
report from an entry Form (using an unbound field name) instead of a parameter query:

Again, in the report's page header (or footer), insert a text box.
For the Control Source, enter the expression
=Forms!FormName!FormFieldNameUsed
the "=Forms!" part is necessary, then you replace the FormName with the form you are passing the params from, and the FormFieldNameUsed is the unbound field name the parameter is from.

Hope this helps, and if anyone sees that this is wrong, please reply!
I may not have the greatest explanation skills just yet.

Reply With Quote
  #4  
Old December 15th, 2003, 03:32 PM
Tmole99 Tmole99 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Location: West Yorkshire
Posts: 8 Tmole99 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks all, with your help I have solved it.

(or rather you solved it

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Query entry in report


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway