Recent content by Twilkes

Thanks, that's a good tutorial site, I'll probably pick up some tips from there. But the example downloads are quite small. I wasn't expecting to lift a naming convention from another database and apply it to mine, more to see what kinds of things other people do when they have 100+ queries in a...

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...

Ah, form/reporting - your initial post said 'from'. :) I think that's kind of what I'm doing with my Excel sheets - this is what the end users of the data will see, and there are only a few users in any case. It wouldn't be worth my time creating a form front end as I'm probably the only...

Could you describe how this would work, based on your understanding of what my queries do? At the moment I have some final queries (tend to be the crosstab ones) that can get pasted straight into a spreadsheet template and sent off to whoever needs to see them; and also an Excel...

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...