Recent content by Antanas_07

This is a nice clever observation. Reminds me something like: You dump guys and I am clever. So there is a situation: I need a chart for 12 criteria. Not like I need, - anyone in Department need the chart to look at any day, by click of the button. Forget Pivot tables they are gone long ago...

Still 5 persons 14 records a day = 90 records a day. 90*365 = 32850 records a year. would it be a concern for 1 table

I can copy the recordsets in to a table during data enter. Will not be a problem. Love the outcome. Thanks for the advice.

I already seen what it does on a my sample. Can not deny the results. I have to sleep on perfection a bit but I see where all it heading.

At the time the idea looked well and it did well generating reports needed. But I had a bad feeling from the beginning. I am considering a new table based on advice. So what will crosstab will give me? I am new to this future.

tblPersonName1 (Design view): Same tblPerson2, and so on ActivityDate Date -date format Activity1 Number - hours User select nr of hours Activity2 Number - hours Activity3 Number - hours The structure is very simple What I need: Table (Normal...

There could be idea of structure of all data collecting corrected or rewritten just for that purpose, but I can not see how to fit column of Activities in the Table1, unless change the table. Thanks for replay by the way.

Table1: Needs correction in the post. It is not clear. Table1 ActivityName1 and below the hours spent; Activity2 and below the hours. ActivityName column heading. I have 14 activities and 5 persons. Each person records a table - Table1. Date on which Activities performed and hours against every...

Could not solve a probably a very easy task. Looks like simple situation: table1: [PersonName], [Time spent on activity], [Record date] table2: [ActivityName] I would like to build a table (and this is a task) Column1 - [PersonName] and names down (Name1, 2...N]; Column2 - [ActivityName1] and...

Hi, I am having the same problem in very simple situation. Running query Based on table Customer Complains. The aim is to create monthly report where I can count complaints every month. Report based on the Query. So I Count the complaints with Month([ComplaintRegisterDate]) and Criteria =1 for...

Hi anyone having the same problem. Even though I had my Report in colours, nice and neat in Access, my boss (it is always a boss) needed to see it in Excel. I looked at numerous forums and articles looking for solution for the problem. I can certainly say - if you are looking for one line of VB...

Thanks for response, The project suppose to be launched this week, last week was symbolic presentation. So it is no data on the table and I use Test database with symbolic data. Literately I do noit understand why it is not working. All books and web say it does. there is an example in the...

I would be more then happy to send a database, but Do not know how to make an attachment to my post

Hi Dx, It appiers that now with a bit MoveLast even without selection of the table column [CCNo] strSQLMonthlyRpt = "SELECT * FROM tblCCMain;" caunts all 7 records. When that bit removed it counts 1. And I tryed to merge results with excel. No luck. I guess I will wait when you got a minute. If...

Hi Rx I did not include anything. SQL as simple as it is. There are so many questions. First The SQL statement to me missing something. If you try to Run Query with statement "FROM tblCCQualityMain" the error would be: "There has to be at least one parameter selected". So for the sake of...