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
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
Date
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
__._,_.___
Posted by: Jessica Hoback <hobackjessica@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar