Hello All,
I am redesigning a database and there are some queries that use the Min total. I understand why you would use this for numeric fields, but I can't find anything online that explains why you would use Min for text fields. Is there any reason why you would or need to?
When I remove the MIN from text fields and run the query, I get a Project Coordination Center error that reads "You tried to execute a query that does no include the specified expression [FieldName] as part of an aggregate function." I take this to mean that if you use Totals for your query, every field needs a total type? Because THAT doesn't seem right...
I am redesigning a database and there are some queries that use the Min total. I understand why you would use this for numeric fields, but I can't find anything online that explains why you would use Min for text fields. Is there any reason why you would or need to?
When I remove the MIN from text fields and run the query, I get a Project Coordination Center error that reads "You tried to execute a query that does no include the specified expression [FieldName] as part of an aggregate function." I take this to mean that if you use Totals for your query, every field needs a total type? Because THAT doesn't seem right...
Query totals: Min
0 commentaires:
Enregistrer un commentaire