Liz
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
And thank you for saying "should have" instead of "should of" that I keep seeing too much of! ;-)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, January 16, 2015 12:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] how to build report
I should have thought of that. My day started much too early this morning.
It is uploaded now. Thanks
Jessica
On Friday, January 16, 2015 1:16 PM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Hi Jessica
Compact your database and then zip it. That should make it small enough. If it is still too big, import just the objects you need into a new database and then zip that one. Keep in mind you shouldn't be uploading any company data. It should be sample data only.
Bill Mosca
---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
John,&nb! sp; My file is too large to upload. I'm not sure how to answer your question.
For the report I uploaded a PDF of:
ReportTrackingRecord - TrackingRecordID (PK)
EvidenceSkillRating - EvidenceID (PK), TrackingRecordID (FK), among other fields as seen on report
TrackingSkillRating - TrackingID (PK), TrackingRecordID (FK), among other fields as seen on report
Handlers - HandlerBadge (PK)
PSD - PSDID (PK), HandlerBadge (FK)
TrainCertDeploy - TrainCertDeployID (PK)
DistanceID (PK) - distance measure (ft, yd, mi)
I have the PSD and Handlers table so I can have the report show names rather than badge numbers
The query just ties them all together and combines the distance! with the distance label for length of track, shows just the year and just the month for the boxes at the top.
I'm not sure what else you need.
Jessica
On Friday, January 16, 2015 12:44 PM, "Jessica Hoback hobackjessica@yahoo.com! [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
It scares me to do this cuz I'm afraid you'll find dozens of rookie mistakes that I've made throughout the database but I will upload the entire database.
There are three reports that will need to have the columns. As I said I didn't use subr! eports for any of them. But that will probably be the easiest wrong for me to right.
Thanks!
Jessica
On Friday, January 16, 2015 12:38 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica-
What is the structure of your tables and the report query?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 16, 2015, at 7:16 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
How do I get each column to show data from a different record - all from the month of January?
I have a report built using a query that joins all of the necessary tables. It works fine to get the data from my first record but I'm stuck on getting the next record to fill in the second column. I exported what I have to a PDF that I will upload - "sample track report". (I didn't use a subreport but I think that will be easy enough to change).
While we're ! at it, at the top of the form there are also boxes to show a running record count for Year to Date and Career to Date. Can you also help me with a formula for those?
Thanks!
Jessica
On Friday, January 16, 2015 11:07 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica-
I would build an outer report for year, month, and user, then a subreport in 3 columns. You might be able to use a Wizard to get a jumpstart on the subreport, then tweak the settings to get three columns.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 16, 2015, at 5:52 PM, hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Happy Friday all!
I am trying to build a report that displays multiple records, each in it's own column on the report. I have already designed the report based off another version already being used. I will want to be able to query by month and user to run the report.
The report would look somewhat like this
Month: January Year: 2015 User: Jessica H
Record1 Record2 Record3
D! ate
Time
Etc.
Etc.
Etc.
Etc.
Each record will have all of the same fields which will make up my row headers.
Is this possible? I'm a novice ! Access user so if it is possilbe I appreciate simplified or "dumbed down" responses. Fingers crossed that I can do this in a query rather than code.
Thanks!
Jessica
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar