Recent content by Big Pat

It is late here in the UK. I'm in Warwickshire ;-) I have no expectation of you doing this tonight, I'm about to crash anyway. I queried the duplicates and apparently they're not REALLY. These are schools from all over the West Midlands region and there are some with the same name in...

OK, try this. There's just ListOfSchools in this. You can just make another table called ExpandedList or something like that? It's actually 643 records and I have just spotted a few blanks and zeroes, so feel free to ignore those. And the appaling punctuation! Really appreciate this!!

Well, nearly 700, yes. I have a table that I imported from Access called ListOfSchools, with just two columns e.g. Schoolname.....Entries Glendale .........15 St John's ........50 Greenway........85 I'n not looking for a normalised database, rather trying to use Access to create a long list...

Thank you, that's kind of starting to get there but it doesn't cut down the task by much. Maybe I didn't explain it properly. Rather than I = 1000, how do I make I refer to the "Entries" field? In some passes I'll need only a handful of records, whereas in others I'll need 50-100. Sub...

Yeah, it's not normally how I'd go about things, but needs must. I'll do it manually if I have to. I don't have 12,000 I have around 700, I need to create the 12000 as a first step and then I'll need to create several other fields for additional data coming from other sources. So they'll only...

Hi, I've been given an Excel list with almost 700 rows and two columns. A: name of school B: number of pupils who met a certain criteria, could be anywhere from 1 to 100. I have imported that list to Access and I will need to add more information for individual pupils. So as a first step I...

Thank you. The most obvious and the most simple - but I hadn't spotted you could even do that!!

Thanks JHB. That worked, or at least came close enough that I could figure out the rest. Your solution worked with the H value on the line where I had left it, but it would not work when I moved it to random other rows. I was puzzled as to why you had used alternatebackcolor, but I used the...

Wasn't thinking straight. I just needed to make the query a maketable, base the report off the new table and delete everything else, to make a copy you can examine. So I have attached it now. I'm no coder, just a self-taught (forum-taught!) hack so I don't know exactly what you mean about the...

I can, but it will take me some time, as I have links to other dbs and to Excel sheets, so I'll need to make a copy with local tables first. It's after 11pm at this side of the Atlantic so I'll leave it for now and try to make time tomorrow. Thanks

The back style of most of the other controls is transparent. Not the two with the percentages, as I am using conditional formatting for those and the colours wouldn't work unless I made the back styles normal. But every else, apart from the Highlight control is transparent. There's also plenty...

Hi, I have a report with a control called "Highlight" (which will be hidden eventually). Depending on which value I have selected on a form, one of the lines on my report will have the Highlight value set to "H" and the others will all be Null. I have verified that this is working. The H does...

I did attempt that, but I found it impossible to get the formatting exactly as I wanted and also to have extra calculated columns alongside the "filtered" data. Maybe someone with a lot more pivot table expertise could make it work, but Google's QUERY function does it for me.

If you want to use Google Sheets, I found that the QUERY function does exactly what I need and it's really simple. The first 40 seconds of this will explain how. Note that you don't have to select all columns. You could use "SELECT A,C,J" or whatever. https://www.youtube.com/watch?v=CE77nmWzjaY

Thank you. I read into some of that and I think I'm getting well in over my head. The laptop doesn't actually belong to me, but to one of the hospitals I work for, so I think a lot of those settings will require an Admin password, which I don't have. But if all else fails, I'll take it back to...