Tony Hine
Last Activity: May 13 '16, 11:27 AM
Joined: Mar 10 '08
Location:
-
YouTube Video - MS Access Building a Cross Tab Query -
[Worker Code] [worker name] [apr] [may] [jun]
a1------------John Doe-------25----15----xx--
a2------------Jane Doe-------36----52----xx--
Why is the worker code different?
Opps --- I see i read Jane as "John"Leave a comment:
-
As to the report, how about three subreports which display each month next to each other?
The SQL for each subreport could be written so that it would automatically pick up the data for the last 3 months.Leave a comment:
-
I still think you need to change your structure. You are getting the data in per month, count per user.
Let's say you're next month is [May '16]
You have 5 user --- ID's 1,2,3,4,5
Counts of --- 43,65,23,87,12
Instead of adding that data into a new field, which is something you should never really consider, then you add the data to fields in a table. The table structure would look like this:-
fldMonth ---...Leave a comment:
-
If I understand your question correctly you have several repeating Fields:- [Jan '16], [Feb '16], [MAr '16], [Apr '16]...
I suspect this is the essence of your problem. This isn't the way you would do things in MS Access this is more like the way you would do them in Excel.
You inadvertently pointed out the problem yourself in your statement "And another complex problem is" The data in each of those Fields is of...Leave a comment:
-
Excel in Access (Part 2)
Could'nt post {{Excel in Access (Part 2)}} easily as it had "too many pictures!"
Will provide links instead -
Excel in Access (Part 1)
Problem for Excel Developers
One of the problems facing Excel developers moving into MS Access is actually the apparent similarity between MS Access tables and Excel spreadsheets.
MS Access is NOT Excel
This similarity of the “look” in both programs, the layout of the data, leads to the Excel developer mistakenly thinking that a database works in a similar way to a spreadsheet.
Flat File Database
...
No activity results to display
Leave a comment: