Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-03-2019, 07:58 AM   #31
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 99
Thanks: 1
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Creating a Report from Two Tables

Hi, I figured that part out, got 44 records, which is perfect. I think what I would like to do is use the report I have and use the index's to narrow down the records so the subreport is only the Timed vales and X values for the indexes >210 < 338 in the Weekly_StartTime_Challenges and >323 < 338 in the Weekly_Challenges table. I really like having the RiseTime, BedTime and all the meals separate, and the Basic Action and Measured and Logged Actions sperate as well. Wow, almost there. I might actually make it for the meeting.

Lkwdmntr is offline   Reply With Quote
Old 09-03-2019, 09:27 AM   #32
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 99
Thanks: 1
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Creating a Report from Two Tables

I just wanted to thank everyone that helped me get this problem solved. It is working well. Haven't run a lot of tests on it yet, but my hopes are high. Thanks Again.
Lkwdmntr is offline   Reply With Quote
Old 09-03-2019, 09:32 AM   #33
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,226 Times in 1,207 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Creating a Report from Two Tables

Quote:
Originally Posted by Lkwdmntr View Post
I just wanted to thank everyone that helped me get this problem solved. It is working well. Haven't run a lot of tests on it yet, but my hopes are high. Thanks Again.
Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 09-03-2019, 10:35 AM   #34
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,392
Thanks: 0
Thanked 558 Times in 554 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Creating a Report from Two Tables

Recommend not having dynamic parameters in query. Apply filter criteria to report when it is opened. Example:

DoCmd.OpenReport "reportName", , , "UserID=" & Me.tbxUser & " And WeekNumber=" & Me.tbxWeek

If you prefer, can probably use TempVars in place of the textbox references, but I have never used TempVars.

Here is a tutorial showing how to dynamically build filter criteria in VBA http://allenbrowne.com/ser-62.html

Also, set sort criteria in report design, not in query. Any sorting or grouping set in report design will override query sort.

And again, why 'plug in' TempVars for display on report? Should be able to pull values from report RecordSource.

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] creating a report form multiple tables mmcgrail Reports 6 11-06-2014 08:48 AM
Linking Tables and Creating Reports based on those linked tables rexmorgan Tables 1 01-30-2011 08:03 PM
Creating a report from Multiple Tables ddmcmullan Reports 1 06-10-2010 10:19 AM
Creating tables for a report nblade Reports 3 12-28-2006 02:44 PM
Creating a report from multiple tables/forms apples76 Queries 4 06-19-2006 10:47 AM




All times are GMT -8. The time now is 01:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World