Search results

  1. I

    Query to Replace headers

    Hello, I have a linked table in Access that has generic names... I also have another table that matches each generic name to a full description name which lets the user know what the generic name means. I want to create a query that will bring out the values from the table but with the field...
  2. I

    query to combine fields from two different taBLE

    Hi, I have two tables Table A has programs Table B has projects I want to create a query that will list all of the programs and projects in one column, is there a way to do this? Thanks!
  3. I

    combining columns but having "enter" between

    Hi, I am trying to combine a few columns in a query but I would like it to the "enter" function added in between each column so for example A b c Text 1 text 2 text 3 result: Text 1 Text 2 Text 3
  4. I

    Report based on query will show multiple values

    Hi, I have linked two tables together in a query that has one primary key (file #) and then a bunch of information (first name, last name, date of birth) then a second table (file # --> which is linked, status --> which are multiple) so these two tables are linked and the data comes out fine but...
  5. I

    Going from Basics to super fancy :)

    Hi guys, I just created my first database with a lot of help from this forum and google, and I am pretty happy with it... now I would like to add something that will make it very useful for the audience... (let me know if i'm just being crazy and I'll give up on the idea) but here it goes We...
  6. I

    Calculated column in Table

    Hello, So I have a column that users will enter a target date, then I want to create a column that will remove 7 days based on the target date, I have gone into the table and set up the column (7daysbefore) to "calculated" and the expression builder opens up... So I type [targetdate] - 7 but...
  7. I

    Access form to populate additional rows

    Hi, I have been researching the internet for the last two days but I can't find anything that's related to access without using javascript... I'm not very good at coding but this is what I would like to do I have one main form that I would like users to enter data that will populate tables in...
Back
Top Bottom