Search results

Yes, I'm aware of that. Was there supposed to be more to the post?

But it works in the top formula. Why would it not work in the second formula?

This formula is working fine as far as I can tell. =FILTER(SORTBY(tblBasketList, tblBasketList[Unit], 1, tblBasketList[Basket], 1), (tblBasketList[Last] <>"") * ((tblBasketList[Crew]= "B") + (tblBasketList[Crew] = "Days")) * (tblBasketList[NL]="")) Rows without a blank name, in the B and Days...

Howdy. I am merging the frontends of a few different databases my job has had me make over the last few years. Since I've been learning as I go, each new database I make has things that work a little better/smoother. I've started merging the front ends so that it's easier for me to maintain...

Appreciate you both chiming in. Yes, it should all be static. It'll be a report run from one system that is then imported into mine. So unless that other system does a big update/change it should always be the same column names.

So I have a spreadsheet that's exported from another system. I would love to create a system that lets someone upload the spreadsheet and it pulls the data into an existing table. What I'm imagining is some code, VBA or SQL, equating the spreadsheet column name to the table name. Then just...

I used the code arnelgp posted in this thread. Did you get a warning about macros being blocked? I re-downloaded the database, and it said that and showed the button captions, Command80, Command76, and Command77. But I moved it to a folder that didn't have macros blocked, and it showed up...

Thank you very much to you and tomasm for your replies. The table only has 99 records, though the field the control is tied to is a foreign key and that table has 654 records. But just in case, I increased the number of records to read to 10000, and clicked the ODBC fields option. This didn't...

Howdy. Thank you arnelgp for the great filter code. I have three filter buttons on one of my forms. They each filter/sort a combobox control. Two of them work fine. One of them however is only partially working. It gives you the option to sort a-z and z-a, but the list of values to filter...

Hello. My name is Rocky. I'm an office worker in the US who's trying to teach himself database, VBA, SQL and other fun things while doing projects for my job.