I have followed the instructions on the link you suggested but still have the same problem. it request date and item twice and every time I move the mouse it requests the information again.
Do you have any other suggestion or a reason why this is happening
justme43
Last Activity: Jul 31 '14, 01:05 PM
Joined: Jan 11 '10
Location: sydney australia
-
thanks for the referral link I am trying to work my way through this at the moment. thankyou again for your help and advise.Leave a comment:
-
Sub report dates. I have report with 2 sub reports attached.
I have report with 2 sub reports. the sub reports provide balances for the main report. this is sub 1 provides balance to end of last month. sub 2 provides balance for current month.
In the criteria of each query I have these expressions
sub 1: <=[reports]![rptstats]![txtdateto]
sub 2:>=[reports]![rptstats]![txtDateFrom] And <=[reports]![rptstats]![txtdateto]
these work fine returning... -
this has worked thanking you very much for your time and patience.Leave a comment:
-
In my reading today I found this I have not been able to try it out I was wondering what you thought of it
If you are trying to count by decades 0 to 9, 10 to 19, etc you can accomplish
this with just some math
...Code:SELECT DateDiff("yyyy", [MbrBirthdate], Date()) - IIF(Format([MbrBirthdate], >"mmdd") > Format(Date(), "mmdd"), 1, 0)\10 AS [Decade], Count(MBRS.MbrBirthdate) AS CountByDecadeLeave a comment:
-
I am trying not to waste your time. I have had some pressing work that has to be completed and that is why I have not posted anything. I have also been doing some reading trying to work out which is the best way to work out my problem as my data base will not let me do anything with it at the moment.
I have tried to export my tables to another data file but i am still having the same problem. Tonight I have spent on this. I am extremely sorry...Leave a comment:
-
Could it have something to do with my relationshipsLeave a comment:
-
Question I have check to make sure the data base is not share I have also checked that the startup is allowing changes Is there something that I dont know about in regards to exclusive use. I am now unable to make a new form its say that I dont have exclusive us and my changes may not be saved
I think I am losing the plot here. I have been checking the integerity of the data base all the way have I missed something or have I just done the...Leave a comment:
-
Ok i can make a query with the details from Client Detail and Assistance Tables The details are From Client Details [Clientno] and [age] From Assistance [Date] This works fine it gives me all the info I need. But when I try to do the other query adding the Age Group stuff I get than the file in opened in exclusive use I can not see whyLeave a comment:
-
Last night I deleted everything to do with the age queries and I was going to start fresh again today. If this does not work I will gladly send it to you. I am so grateful you are interested. I dont even have a sole here that has any idea of what I am talking about.Leave a comment:
-
I can get the first Query but the cross table query say the are to many rows and if I use columns to many columns. I was trying to pull data from different tables but that did not work so I did a querytable I think they are referred to as action queries i this It kept saying that something was opened in exclusive use.
I have most of the other things I need for my report they are Nationality, Benifits Employment Postcode and gender. but I...Leave a comment:
-
I do so thank both ADezil & NeoPa for your advise I will do some more reading I really need this to work To date everyone has had their own DB and they have been hand writing their reports About 6 months ago I did an excel program for the reports which works well but they still have to double handle the information. I have used Access in the past but not for this type of reporting and I must say I am at a loss at the moment. So I do appreciate...Leave a comment:
-
thanking you I will try thatLeave a comment:
-
is there away to put an expression or function in that will group even in excel you can group with out making new tables I would perfer to have a function or something likeLeave a comment:
-
grouping data by age
Hi
I am having trouble getting my head around how to go about group ages
I have a querytable which holds the information that I need that is the age field What I want to do is group this by ages groups eg under 19, 20 to 29, 30 to 39 etc.
I then need to put this information into a crosstab query to do the count
I have tried to do this several ways but am at a loss as to why I am not winning
I would appreciate any... -
thankyou I am looking at this now I am getting a little confussed at the moment with what i am doing but I will persist I am so grateful for your timeLeave a comment:
-
you are not kidding with the inexperience Excell I am brillant with and have been able to do this. The probable is we need something that works uniformly accross all sites so I am trying access I really need this to work I will read this and also look at cross tabs.
thandyou for your time both replies I received
I have read and I am rather sure I have covered these points tyLeave a comment:
-
count if function
I have a data base that records every client (clientdetail table)
We also record every time this person receives assistance from emergency relief. I would like to count what countries these people come from and how many people come from these countries (Service utilised table)
This also needs to be done for PostCode and a few other fields
This needs to happened between a date range weekly monthly quarterly annually
Is...
No activity results to display
Leave a comment: