Search results

  1. S

    Formatting Checkbox Output

    I have a form which contains a checkbox along with some other Yes/No Controls. The form updates a table. When I run queries on the table, the value shown for the checkbox is always either -1 or 0 - now I understand that is correct, but is there any way to display that as yes or no in in the...
  2. S

    Upper Case in SQL View

    Hi all I have a DB which uses a union query. The DB is based on 3 tables. Everything works fine except - The 3 tables have the format property set to > (to force upper case output) This works fine on all my other queries, but on the Union Query, all the data comes out exactly as it was...
  3. S

    Using the For ..Next Loop

    I'm really struggling with this - and have been for about 4 days !! I have a query called SuppList that contains two fields - supplier and Suppname and has 101 records I need to loop through this query and use the supplier in each record as the criteria in another query and then output this...
Back
Top Bottom