I am creating a database for budgets that are pulled from another source. It's an attempted workaround to get the info I need filtered and keep track of it accordingly. Not really what access is intended for I know, but It will work to accomplish what I'm trying to do.
I named the table the budget project code number (example below the table would be named 1000). Can I somehow refer to that to populate a column in a query?
The goal is for it to look like this:
Project Code Other Info 1000 asdfa;sljfkdl; 1000 ;akdfj;lsdjf