Sequential condition

[saman]

Hi, How can a text report on the "C" from "rptA" which involves making a record is 17,22,23,27?
please look at the attachment file.thanks

 

[Geotch]

I looked at the database, but I'm having trouble understanding your question.

 

[saman]

Hello and thank you for your attention.
I just rows 17, 22, 23 and 27 with conditions intended to display the report.
The rest of the rows do not display

 

[Geotch]

change the record source of your report to this:

SELECT DISTINCT tblA.a, tblA.b, tblA.c FROM tblA WHERE (((tblA.a)=17 Or (tblA.a)=22 Or (tblA.a)=23 Or (tblA.a)=27));

 

[saman]

Thank you Geotch
Do not want to display the result of their rows, but rows with no results to display.
My problem with this picture.
How can I make consecutive terms?

 

[Geotch]

Instead of using vba code, I created a cross reference table. Created a query with it and your table. I had to convert B to a number using Val(). Then created some if statements.

The query I created is called qryGeof and the result you want is called FinalResult. Hope I understood it correctly.

 

[saman]

hi Geotch;thanks for your help
Results will be announced soon.

 

[saman]

hi Geotch;Many thanks for the guide
One other question if I may:
How do I attach an image field values ​​as b?
For example, records (rows) to give 20 and 21 in the report show?

 

[Geotch]

I'm a little confused with the question. Do you want to do that calculation on every consecutive entry in the database?

 

[saman]

Sorry Accept
How to change the query found in the c؟
thank

 

[Geotch]

Sorry, still don't get what you are trying to do, can you show me a sample in Excel?

 

[saman]

Sorry, still don't get what you are trying to do, can you show me a sample in Excel?

I want to design a query by you to a sub-Report of the report to use.
If you can "c" condition in the query field for me to edit?