making "flashcards" via an access report

[janelange]

I want to use access reports to create flashcards with an english word on one side and a spanish word on the other.

I have a table with corresponding english and spanish words.

I have a report set up with 3 columns, where each entry in the column corresponds to a particular spanish word.

It seems reasonable to set up another *practically* identical report for the corresponding english words.

Here's the rub:
I want to print the corresponding words on the opposite side of the same page. The problem with this is that for each row of three "cards", the corresponding report for the other side (which contains the translated words) needs to have the columns appear in the opposite order.

It's not that complicated: If If I have words A, B, and C, on one row of my "english" report, I'll need the order to be C, B, A for the "spanish" report.

Any ideas on how to solve this problem?


Thanks,
Jane

 

[ZmrAbdulla]

Create the report and re-arrange your fields in the report design view like below.
AE-BE-CE----CS-BS-AS


________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[janelange]

Thanks, but I'm not sure how to set up the report
so that all three "cards" in an entry display unique words--

My tentative solution has been to use 3 columns to display the entries (using the page setup) which means I only have one field per entry and thus cannot shuffle them around as you suggest.

I'm not the most experienced report maker, so I'm hoping the solution is blindingly obvious--or not too complex to implement

JL

 

[ZmrAbdulla]

Can you show me your table setup? and some sample data,and the report style that you prefer as well in a graphical mode.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[ProgramError]

Presuming you have a field which you are using as a keyfield,
how about creating a query with all the data you want to print/output with the keyfield sort order set to assending and make another identical query with the sort order set to descending. Not forgetting to change the word field from spanish to english.


Program Error
Programmers do it one finger at a time!