Search results

I'm not talking about naming conventions as in tblThis or qryThat, but I have 100+ queries, many of which do similar things from slightly different angles - e.g. a query that gives the total sales per store per month; the same query but per store per product per month; the same query but per...

Hi, I’m putting up my Access table/query names for critique, because at some point I’ll have to hand over this database to someone else and I want to see how they might react. So if you opened a query list and saw the list below, would you be able to find your way around, or are there too many...

I have been using the ConcatRelated function (allenbrowne.com/func-concat.html)and while it works fine when the data comes from a table, but it doesn't work when the data comes from a query. The green 'running query' bar appears for a few seconds, but then when it tries to display the data it...

I have a number of Excel worksheets to keep some basic data in, mainly because it's just easier and nicer to maintain data in Excel rather than going into Access tables, I use the filter/sort/formulas of Excel to maintain it, and also because there are people who will have to edit it that aren't...