Search results

  1. J

    Turning many columns into 2

    Every year, we receive data about what exams our students will be taking. This comes in a standard format that can't be altered until after we receive it: student_id 1 2 3 4 5 6 7 ... 40 1234X 1 3 4 6 2234X 2...
  2. J

    Would like help with error checking/validation (I think)

    Hi there! I've written a function (my first!) that uses a switch() against a query to set the text in two fields of a table and I'd like to be sure that the row it's getting the data from and the row it's setting the fields in match. Specifically (and someone reading this probably already knows...
  3. J

    Number of values matching criteria across a row

    Dear all: I can't seem to figure this one out on my own; I'm trying to create a query that counts the number of values in fields across a row that match certain criteria. For example, the data I'm querying looks like: ID 01-1 01-2 02-1 02-2 03-1 03-2 04-1 04-2 1 85...
  4. J

    Using data in one table to create fields in a new table

    Hi there :) I'm not sure if I've picked the right forum topic for this... It's not a straightforward table question, and I think the only way I can do what I need is with a query of some sort. Apologies if it should have gone in 'Tables'... The situation is: I'm creating a database (using...
Back
Top Bottom