Recent content by Butterfly_Collector

Thanks for your reply. I am however a relative novice when it comes to Access. :confused:

Hi, I am trying to run formula field a query to produce a particular date: [Date]: IIf([Document_Number]=1,"03 Jan 07") When I try to develop the formula further: [Date]: IIf([Document_Number]=1,"03 Jan 07"),(Document_Number]=2,"23 Aug 07")) etc... A syntax error formula appears. Can...

Hi, I’ve had to go back to the drawing board. I’m not sure whether I should be creating 8 tables based on the number of claims there are or create 3 separate tables totalling 4000 rows which contain: Table (Claim) ID (Primary Key) Excel ID (Based on original spreadsheet and purely as a means...

Hi Gemma, I've managed now to condense all the information into 11 columns. I originally had 8 Claim Documents which contained information concerning the issue of drawings. Within each claim there are a number of sub-events so one drawing (e.g. #366) may be applicable to more than one...

Right ok, Just so I know I am going along the right lines here. (I am currently in work and access to internet is somewhat restricted).... The raw data I had from excel I have now placed on 6 separate tables in access according to the broad area they relate to. (Any calculated columns I...

As an afterthought if the master table is only to contain the raw data can I just not delete the last numerical columns on the right hand side and from using the form I have devised (based on the query sheet) run the formula on there? I have claims 1 to 8 on the form as a tick box. :confused:

Thank you both for your replies Galax / Gemma. I managed to find something via google for normalization: http://www.devshed.com/c/a/MySQL/An-Introduction-to-Database-Normalization/ I couldn't quite grasp the jargon. I'm a bit of a novice when it comes to access I have to admit. I am starting...

Mods - feel free to change the title of the thread to suit. Hi, I'm not fully conversant with access and I've only been using it for a week! The spreadsheet I have been using has become far too big with over 52 columns and 2500 rows of data - hence my question. (I've attached a screenshot to...