Recent content by amaklop

Hi. Please follow this thread on http://www.utteraccess.com/forum/index.php?&act=Post&CODE=02&f=54&t=2050915&qpid=2697603. It was cross posted

Sorry, I'm new to this. Is my thread/question still "active" or do I need to post a new one?

Hi I have a table with a corrupt record (Chinese character in one of the columns). I'm trying write code to resolve this should it happen again. I know ... we should rather try to ensure the db doesn't become corrupted .. however ours still manage to be from time to time. So the corrupt record...

Ahh ... Thanks I never thought of disabling the buttons. That will be much easier :)

Hi I have a home page with various buttons. Depending on the user's security group, only certain buttons will be available. However, when the buttons are hidden that he cannot see, there are big gaps between the buttons. Is there a way that I can "auto arrange" the buttons after I've hidden...

Well ... I seem to have solved it .. I took q_ageanalysislines, removed one of the union statements to see if I could eliminate the problem. The results were correct. I added the union statement back again and now the query returns the correct results. Don't really understand why that...

Although ... as I replied to arnelgp .. when I do a sum(credit) using the sql of the query, I get the correct figure: select sum(credit) from ( SELECT customers.company, customers.id, customers.custaccno, customers.address1, customers.address2...

Ok, here goes ... this is my q_ageanalysislines query. I'm an Oracle sql developer so my access skills aren't so hot. This query might not work that well on access so any tips will help : SELECT customerid, c.company, fix(100*v_totage120)/100 AS totage120, fix(100*v_totage90)/100 AS totage90...

Hi grandpa, sorry only saw this question now ... In the first query, there is a reference to something called "AGE" and it is involved in ordering records (GROUP BY). What is "age" in this context? Is it a computation in the query that is the record source q_ageanalysislines for the two queries...

LOL ... this is getting weirder .... SELECT count(1) FROM q_ageanalysislines where customerid = 634 and credit = 6000 Returns : 3 SELECT count(1), min(trndate), max(trndate) FROM q_ageanalysislines where customerid = 634 and credit = 6000 Returns: 4 - 2017/05/01 - 2018/07/07

arnelgp, I did what I think you suggested. I took the base code of the query q_ageanalysislines, put a select sum(credit) around it and I got to the correct 278111.46. So the issue comes when I sum from the query q_ageanalysislines

Sorry arnelgp, getting back to your post ... do you mean running the query against the table that sources the q_ageanalysislines? The q_ageanalysislines is a complex query with a couple of union statements and 5 union statements :(

SELECT count(1) FROM q_ageanalysislines where customerid = 634 and credit = 6000 Result : 3 SELECT * FROM q_ageanalysislines where customerid = 634 and credit = 6000 Returns 4 records

SELECT count(1) FROM q_ageanalysislines where customerid = 634 Result : 83 SELECT count(1) FROM q_ageanalysislines where customerid = 634 and trndate > datevalue('2016/05/01') Result : 84 SELECT count(1) FROM q_ageanalysislines where customerid = 634 and trndate <= datevalue('2016/05/01')...

Breaking it down even further (sorry arnelgp, will answer you just after this) : SELECT sum(credit) as tot FROM q_ageanalysislines where customerid = 634 Returns : 272111.46 SELECT sum(credit) as tot FROM q_ageanalysislines where customerid = 634 and trndate > datevalue('2016/05/01')...