Using a form to select data from a query using SQL

[swills]

very close

just the last point, i will literally only need the crosstab query to be shown, i will create the report seperately

you know how to do it?

 

[Colby]

give me a few minutes and I will letcha' know where I am at.

 

[Colby]

See if we are getting any closer. The form updates the qryTest and then the crosstab uses that recordset with tblMem to produce the crosstab results. I added on record on tblMem ID3 for my own testing.

Let me know what you think or whatelse we can tweak.

 

[swills]

i think you may have hit the nail on the head here. is it possible to hide the column with the heading <> in qryMemAll? also what is this showing just out of interest? cheers

also i really need to get the fields shown as they are in the table and not in alphabetical order if thats possible.

cheers

 

[Colby]

is it possible to hide the column with the heading <> in qryMemAll? also what is this showing just out of interest?

go into the design of qryMemAll(2), doulble click the join and select option 1 in the join properties window.
it is/was showing the other data that existed in tblMem but not in qryTest.
The change above will get rid of this column.

As far as resorting the records, when you use a group by I believe its automatic on the alpha sorting. I don't know of a way to get rid of it. My apologies.

Hope I was of help

 

[swills]

Cheers colby you have been a fantastic help, thanks alot. couldnt have got this far without u

 

[Colby]

glad to help, let me know if I can help with anything in the future.