Search results
-
S
UPDATE field in table based on DISTINCT values
Thank you spikepl. Where do I setup the values for PIDMPrevious and regsYearPrevious? And will this UPDATE the field in the table instead of creating a separate query? If so, what would that look like? Thank you. -
S
UPDATE field in table based on DISTINCT values
Yes, thank you. Okay, so I'm preparing data for reporting and graphing by Year. There are more fields to this table that make the record unique. For example each record constitutes a class a student took with credit hours. So, I can sum the credit hours per year the way the data is, no... -
S
UPDATE field in table based on DISTINCT values
Thank you Pat, I spent all day Monday and Tuesday trying to figure this out. I thought it was just me...that I could not figure it out using an UPDATE query. I wanted to make the update to the table without having to write code. Updating the field on this table is the last step in a... -
S
UPDATE field in table based on DISTINCT values
Below is a sample of the table with the data. I manually added the 1 and 0 to the hc_Year field. However, I would like to create an Update query that will add a 1 to the hc_Year if its the first instance of PIDM & regsYear and add a 0 to the records that are not the first instance. Please...