Recent content by bberrelez

Thought about that but then I might as well just copy my queried field and insert it back in the original table. That would work but I was hoping to acheive the autofill. The program is using an ODBC connection to Access I could use Excel, either way I suppose. Is there a way to accomplish...

Well I'm doing this as a data import into an accounting program. I need this special D01 number to automatically create a new line into our Invoices. I would like to be able to dump a huge amount of invoice lines that I am receiving in a spreadsheet, copy this data in, run the query and have...

Thanks! That is what I was hoping to get. Would it be possible to take these results and insert them back into the receivables table in a new column? I am hoping I can acheive an almost autotext result, hopefully I am not overkilling this thing.

I am making this harder than it has to be i'm sure. I had a previous post of auto-texting a field, well why can't I just take two fields I have, such as the ID field which is an autonumber field and combine that with a type field that I have which is D. If I could merge this in a query...

I was wondering if anyone had any information they could point me to that will show me how to automatically assign a value to a certain field. I already have a primary key. I added a new field and I was wondering how I could go about adding a specific value multiple times. For instance...