Hello
I have used access before but about 10 years ago so I am struggling to remember how to create fields and format etc. I need to create a Request to Purchase database. Does anyone have a template? I need help with the following:
1) Format the primary Key so that it defaults to 'RTP00001', 'RTP00002' and so on without me having to type in anything into the field.
2) Include a VAT formula to calculate Totals if they include VAT or VAT if not included
Any help you can offer will be much appreciated
Thanks