Recent content by dal1503

This table was imported from an Excel spreadsheet, which itself was exported from an online database that calculates age live... if it was my own database I would use date of birth not age too, but thanks for the heads up :) Secondly, thank you for your response. After a small amount of...

I have a table, with each record being a separate person. The fields I have are: Name Age Address I need to write a query that returns all records that have people aged both under 18 AND over 18 living in the same address. Just to clarify, I need the records to have the same address, and to...

Then I will do it manually :) I'm not very good at coding at the moment. With a lot of googling I've attempted to write a comment on each line of code, either saying what I think it is doing, or writing any questions I have about that line. If it's not too much trouble could you have a look and...

Sorry for another question... Is there any way that your database can accept a string instead of a number for Address1? Some of the houses have a house name instead of a house number, for example: all (1-29, 31-53 odd, The Cottage, The Farmhouse) If this is too difficult or not possible then...

Ahh yes, that's brilliant, thank you! I know this may be asking a bit too much, but is there any way you could send me a version of the code with some brief comments attached to explain what each line/section of code does? I'd love to understand it further so that I can create similar solutions...

JHB, you are an absolute superstar! I can't thank you enough. I looked at the code and tried to understand what was going on so I could learn from it but I got completely lost, so all I can do is offer my many thanks! Two follow up questions: If I want to add a new load of addresses, I add...

Sorry, I tried to simplify my original example to try and explain what I wanted to achieve. For clarification: "all (73-79 odd, 80-96, 98, 101-111 odd)" The 'all' just means that all houses on this street are to be included, so it can basically be ignored. The numbers contained within the...

My example shows each street on its own row, but I need to show each house on its own row. If you look at the sample database I attached in my reply to JHB above it may make it clearer what I'm trying to achieve. Thanks.

I've imported a portion of the spreadsheet into an access database which is attached. I'm sorry I have no idea about writing VBA code with a DAO-dynaset, loop and Split function! If you can help me at all now that you can see my database I'd be really grateful. Thanks.

I've got a spreadsheet full of addresses that I need to put into a table in an Access database, but the problem I've got is that in the spreadsheet the addresses are listed as, for example: | House Number | Street Name | Postcode | | _____________|____________|_________| | 1-30 (all) |...

Do you have any suggestions on how I could store it? The area would always be based on house number and postcode, and if the areas changes I would want it to update the record in the People table. However, I can't think of a way of storing this data without violating normal form.

I need it to be stored somewhere so that I can run queries based on the data e.g. number of people that lived in AreaOne. What would be the best way for me to structure my data? Sorry for all the questions, I'm struggling with this so thanks for your help

Thanks for your response. Would this also write the result (e.g. AreaOne, AreaTwo, Not in Area etc.) to the 'Area' field in the 'People' table?

Posting this in General as I wasn’t sure whether it best fit under Tables, Queries or Forms. In table ‘People’, upon a user entering their house number and postcode (UK zipcode), I need the ‘Area’ field to be populated accordingly based on the addresses stored in the ‘FS_Area’ table. What...

The database is working fine now, thank you. But can anyone shed any light on why this error occurred in the first place?