Search results

Sir, now the error seems to be solved. But I want to know the reason of error

Sir today I was testing the Db and I noticed some error in the yearly progressive number. There were 61 customers in the month of April, 109 in May, 95 in June and 6 in July 2021 so progressive of april is showing 61, May 170, but in June it is showing 258 instead of 265 (61+109+95) again in...

Sir Thank You for your valuable guidance Every thing is working fantastic

Sir my report page requires a fiscal figures of progressive customer details as in the report, but it should take only current fiscal year progressive counts. Sending the screen shot of report where the maternal age > 35 should be showing 0, instead of 11 (which are the previuos years figures)...

Sir the yearly and monthly autonumbering is working fantastic Sir only now I require the daily autonumbering. Means a new column of Daily numbering Secondly Sir, about that progressive Yearly number, it is taking the overall progressive from previous years too. I want only progressive for the...

sir similarly can we have a autonumbering on daily basis too

Sir I was unable to use the function you gave me Sir I am using dd/mm/yyyy format

How to start renumbering from a certain date on monthly and yearly level in a append query. So for every year, for example 1st April to 31st March we get a new serial number and similarly on monthly ground from 1st date of every month. Every Year on 1st April the Yearly number should reset to 1...

Sir I am unable to implement the public function in my query. Please help Sir I am using a dd/mm/yyyy Date format, so please correct the same attaching the Db

Yes Yearly should reset to 1 on 1st april every year and Monthly to 1 on 1s of every month

Sir sending the SampleDb with a CustomerVisit_tbl with few data of different date. I have labelled its Yearly and Monthly serial number incremental on year and monthwise manually. How to get the same as I add the rows to the table by use of a append query, so I need not do it maanually. So to...

Sir the progressive values are reflecting as expected, but Sir, how to start renumbering from a certain date on monthly and yearly level in a append query. so for every year from example 1st April to 31st March we get a new serial number and similarly on monthly ground from 1st date of every month

Sir after what you guided me, I have designed as per your guidelines a single query to count age and issues in the month and get zero for null values. Sir now I am trying to get a progressive yearly number for the certain fields in query like progressive advanced age and progressive total...

Thank You Sir SELECT Month([DateCreated]) AS [Month], Year([DateCreated]) AS [Year], Count(IIf([Age]<18,[Age],Null)) AS [Age<18], Count(IIf([Age]>=18 And [Age]<=30,[Age],Null)) AS Age18_30, Count(IIf([Age]>30 And [Age]<=35,[Age],Null)) AS Age31_35, Count(IIf([Age]>35,[Age],Null)) AS...

Sir I want to get the total number of customers in certain month of certain age groups like < 18 year, 18-30 years, 31-35 years and > 35 years Similarly I want the know the total number of customers in certain month who have no living issues, 1 living Male only, 1 living Female only, 2 or >...

No Sir, this also not working and not fetching desired zero value count

Sir Attaching zipped file for analysis. Actually other than single age count query, can we have a single issues count query. HELP

Tried Sir your code, still same problem persists. When the count if null in any column all fields go blank

Tried this SELECT IIf(AgeAll_qry.CountOfAge=" ", 0, AgeAll_qry.CountOfAge) AS Expr1, IIf([Age<18_qry].CountOfAge=" ", 0, [Age<18_qry].CountOfAge) AS Expr2, IIf([Age18-30_qry].CountOfAge=" ", 0, [Age18-30_qry].CountOfAge) AS Expr3, IIf([Age31-35_qry].CountOfAge=" ", 0...

No Sir, not getting the expected count of zero, if there is no person within that age range. All results go blank, even if a single CountOfAge is blank