Search results

Hi MickJav Thank you for your idea. I did use cross tab of my first query and manage to get result. Than you all guys for helping me to solve some problems I had. More is coming to tight up my project.

Thank you Mick.

Yes that is my plan.

Yes you posted yesterday. I forgot on that and did not try your solution yet. Thank you for the answer on my previous thread.

No I did not start because will create report from this query.

DoB is field in tblReg where query checks difference to Date() and set value in unbound box named Age. Need to make temp table Rt for every child to count how many children by Age. I have used 'One' quotes and gives me the same result. Then I changed to [One], but result is the same.

It does not work again. I think problem is that query engine cannot calculate that much information. Thanks

Thank you for quick reply. Choose also gives the same error.

Hi everyone, I am trying to write a query in Access 2013 to get Age for children from Zero to Seventeen years old, but getting an error "Expression too complex in query expression 'Switch'". SELECT Rt.*, Switch( Rt.Age = 0, [Zero], Rt.Age = 1, [One], Rt.Age = 2, [Two]...

Thank you a lot MajP. Will certainly try your way and will post back the result. You are excellent in teaching us beginners and hope to learn more advises from you. Thanks again.

It is working like a charm. Thank you very much. You have put really excellent effort to lead me all the way. I will try now to count total number of IDs for every Age range group. Thanks again and hope to hear you again in the future.

Thank you for your advice. Could you please suggest since I am a beginner in programming.

Problem persists in syntax where asterisk * is highlighted.

Excellent it is working this Arnel's method. Thank you very much. Now can we try to find age range.

New error produced on this short query. Now DoB field is highlighted.

I did remove it and still getting the same error. It is like cannot select from my tblReg. FROM is highlighted every time I run the query. Corrected all typos and getting a new error. Error is highlighted on asterisk *

Thank you MajP. It was typing error in this thread from my side. I am still looking for the solution.

Yes I did substitute all fields from my table. And my table name is tblReg. Just to inform my date format is Short date dd.mm.yyyy. By the way I am creating queries in MS Access.

Thank you for your help. I am getting an error in FROM tblReg part when I run the query

Thank you for the quick reply. Yes you are right, but I am not that expert in access. It is easier for me to create query from the table. In my case I need two queries where one will calculate every child (e.g. O for the child old less than one year, 1 for the child old 1 year etc.. al the way...