Using SQL or query to insert unbound data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I hope you can help.

I have a combo box on a form (cmbCMMIPA) that shows the subject for
interviews. These may be single, e.g. "PP", or multiple, e.g. "PP/PMC".

I have created two variables, strPA1 and strPA2, which are split out from
the value of cmbCMMIPA.

Each process area has its own list of practices, which are allocated to an
audit ID based on the value of cmbCMMIPA. I can do this if the value is a
single value, but cannot work out how to create an append query (or SQL) that
would append the practices relevant to BOTH process areas (e.g. if
cmbCMMIPA.Value = "PP/PMC", then strPA1 = "PP" and strPA2 = "PMC").

I would like to know how to write a query that would append the practices
for the first process area and then those for the second process area into
tblCMMIRatings.

Can anyone help?

Many thanks
 
This is quite confusing as we're not familiar with your system. It doesn't
sound hard otherwise. Could you explain the data relationships of each table
involved?
 
It's alright - I got it sorted! I needed to create a blank form and use the
query builder to add the relevant tables needed for the query.

I then copied the SQL into my module and amended the syntax where necessary.

Thanks anyway!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query with multiple joins 1
Access 2010 append query to SQL is very slow 0
Insert row, table to table - where append goes to correct record 2
Copy one or Multiple Records 4
Append Passthrough Query Results to Local Table 2
extract items from list in single field, revisited 4
How to write an append query on a recordset 1
runtime error 3075 using sql insert query where data has single qu 2

Back
Top