Creating a simple Request to Purchase Database

[liz81]

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

[ConneXionLost]

Hi liz81,

Welcome to the forum!

If you're referring to data model templates, then try databaseanswers for a large selection.

For your Q1. In Table Design view, select your primary key field (Autonumber) and set the format as:

"RTP"00000

For your Q2. This will depend on how you tell the database when to include VAT, but an Iif formula will likely satisfy this requirement.

Cheers,