Search results

I'm sure this is already answered somewhere but didn't know what to look under to find it - sorry. Let's say I have a table (1) of a list of projects carried out in 5 towns. I also have a table (2) with just those 5 towns listed and a one-to-many realationship with table (1). I want to change...

Thanks for everyones help. I'm not sure that I follow the last piece of advice. GumbyD, are you saying that Client and Country from Table 2 should be primary keys as well? I have looked at the properties in design mode but don't really see anything to be playing with in respect to this problem...

Maybe I undestand wrong but this is what I have: (pk - primary key) Table 1 Client (pk) Country (pk) Address Contact Table 2 Project Name (pk) Client Country Description Type I have a one to many relationship from Client and Country in Table 1 to Client and Country in Table 2. This should...

I know I'm going to explain myself very badly, so I only hope someone knows what I'm getting at: You have a Table A with columns: Client (Primary Key), Country and Contact and a Table B with columns: Project (Primary Key), Client and Country (for example). If the relationship between A and B...

Spot on! I can stop pulling my hair out, now! Thanks very much! damie.

Hi, I'm just starting to get my head around the basics of Access, and am following a tuturial on using the iif function in Queries. I have a table with a "Credits" column, and with this table selected, I want to create a field which says "Full year" whenever Credits is more than 3 and "Half...