Hello, all!
New here, so please forgive if this has been answered before. I use
MySQL most often, and can use the commands:
    show tables in [databasename];

I appreciate any help I can get.  I have a book on this but I still
can not get it.  I am getting a syntax error on my IIF statement and I
am not sure where I should put the IIF statement.  Right now I have it
placed it in the report under the details section but I wasn't sure if

I use a make table query. A field in the output table is a combination
of three fields and the syntax is:
NewField: [Main]![Field1]&[Main]![Field2]&[Main]![Field3]
Fields 1 through 3 are memo fields, yet the field type for NewField in

I am making a database for a dress shop, which hires and sells prom
dresses. I am creating a form where the user selects the customer
using a list box and then using a combo box to select a dress. The
combo box is connected to a query which looks in the dress information

I need six teachers to provide me with a small amount of data each
week. Their IT competence varies from reasonable to barely literate
(but they're great teachers!). I want to give each one of them a tiny
subset of our main database by way of the Package Solution Wizard and