I have a one to many relationship between multiple tables in Access. In one particular query I am pulling data from the parent table where the value of Results_ID_start is the direct relationship to Results_ID in the Results table. When I query the two tables I do a one to many relationship that allows me to have the file name, date, etc. of the parent table linked to the series of results in the Results table. The problem is that I have one line in the Query that has the parent information linked to the start of the results series and I want the parent information to be displayed on every line for that series. Is there a way to do this?
Again, the filename and date in the Query are only associated with the first Results_ID that matches the Results_ID_start in the parent table. So periodically I have three lines of data that have empty cells for the filename and date.
I know in Excel I can sort on blank cells in a column and then type in the expression =[uparrow, shift ctrl enter] to populate the cells with the information from the cell above.
Any suggestions?
Thanks in advance.
Steve
Again, the filename and date in the Query are only associated with the first Results_ID that matches the Results_ID_start in the parent table. So periodically I have three lines of data that have empty cells for the filename and date.
I know in Excel I can sort on blank cells in a column and then type in the expression =[uparrow, shift ctrl enter] to populate the cells with the information from the cell above.
Any suggestions?
Thanks in advance.
Steve