how to have a query with expression in ms access web database

[mana]

hello

i want to make a query in ms access web , to count the numbe of ids of a table group by two other fields.
but in ms access web it is impossible to work with count function. can you help me please how i can do this. in addition group by symbol is also disabled and i don't know how it works in ms access web. please help
thank you

 

[aubrey1983]

base from what i understand from your question, my quick fix here is to create two queries, first is to group by the two fields, create a dummy field that has a default value.

then another query to group by the dummy field, then you can use a summation to count.

hope that helps, if you have example, that would be better for us to understand ur question.

-Thanks-
Aubrey

 

[mana]

hello

but this is web access and group by is not enabled in creating a query
the attachment is my database
i want to have based on checkpoints table:
Number of checkpoints for each area and creation date

 

[mana]

i also don't inderstand your solution
can you explain more please?
also group by is not active in ms access web database
how can i active group by in ms access web database?

 

[aubrey1983]

I see, i have not done so much development base from what you have. but have you tried using the Create Query in Design view? not the Web Query. not sure if that works for you, but after i tried using that, the Group by functions are available there.

check the attachment.

 

[mana]

but this is not a web query and it is in windows access. so the group bys are enabled. but i need group bys in a web access database. do you know how ?

 

[aubrey1983]

sorry, i haven't done it.

 

[Minty]

Apparently according to MS you should be able to use data macros to achieve a group by equivalent https://support.office.com/en-ca/ar...35-8e51-45ce-9269-8942b0deab26#__toc262221095

Is there not a sample database that shows these types of things as working examples?