First of all i'm new to access. I'm making an exam registration system
database. In it's candidate table, there's a subjects field which is actually
a multiple selection listbox that get's the values from another table. The
subjects table has their names and codes.
The problem is that when I want to make a report using the wizard, I see all
selected and unselected values in the listbox in the report. I wanna see just
the selected subjects with their code.
I think I have to change the query for the listbox in the report. But i'm out
of ideas to what to do. If u need I can attach my database file.
and sorry, if it's on the wrong place, I dont exactly know the best place for
and I have windows 7 64bit and office 2010 64bit
No need to post the whole database, simply post the SQL of the Listbox, the one of the report and an explanation about what criteria should be applied to restrict the range of the items into the listbox.
I'm not sure you would find many people here (or almost anywhere else) that use the 64 bit version of Office right now (many don't even use Office 2010 32 bits), so loading and opening your database could be a problem if you posted it.