Search results

Yeah I tried a crosstab query but don't think it'll work. Your suggestion will work if I insert another field where I count the credit notes per account per quarter. If I was going to do the count in Excel I would sort by account number and credit note date, and then write an IF statement...

Thanks for that, it helped a lot, although my credit notes aren't all numbered 1-6; they're all unique and random numbers which this then didn't work with. I can put the raw data into Excel first to put in a 1-6 column to allow me to do this, but is there a way to do it in Access with unique...

Another way to do it could be to create a concatenated field in each table combining plant and code, and then match on that.

I have some data in the same format as the Raw Data table in the attached file, and I need to change it into the same format as the Desired Format table. So it's a list of account numbers and credit note details; and I need to have the credit notes for each customer on one line per account...

I couldn't work it out I'm afraid - I've never used forms before which isn't helping me and I don't use Access that frequently; most of the knowledge I have in it is using update queries based on my much better knowledge of the functions in Excel. I've attached my database for you to see...

Thanks a lot, I'll give this a try.

I've got some data that's in the format of:- Account No. | Credited Date | Credit Amount | Credit Note Number 123456 | 01/04/2012 | 100 | 3000123 123456 | 05/04/2012 | 200 | 3000124 654321 | 01/04/2012 | 100 | 3000125 456789 | 01/04/2012 |...

Hoping someone can help me with this; I have a file which shows inventory levels submitted every Monday, along with sales between each week. I need to be able to create a query so that someone can enter a start and end date and they will be shown the difference between the opening and closing...