Help needed on table design!

[leftright]

Hello! Please help!

I've an existing database for my company. In my database, I've a master file that has column A as name, column B as title and column C as grade. Is it possible to have the table design such that when I search using 2 different query forms, one result will show column A as grade (as opposed to column C) and the other result will show column C as grade?

Please help me solve this, thanks in advance!

 

[pr2-eugin]

It all depends on how you call your Query, if you are using DoCmd.OpenQuery method, then you need to save two queries with the format you wish to use.

If using VBA, several method one is Opening a Recordset, another method is using QueryDef to edit the saved Queries.

If you are not great with VBA, then stick with the first method i.e. using DoCmd.OpenQuery.

 

[leftright]

Thank you!