suppression if date not within another date

[rrmcguire]

Hello,

I have a series of numbers

i.e.
1
2
3
4

with dates assigned to them which are sorted per customer

so

Customer
1
2
3
4

then, each has a "billed" date, which I only need to display the values which are within another date, the "last activity" range of the customer. Is this possible, basically to suppress the records where the billed date of the number values is not within the last activity range of the customer

thanks

 

[fisheromacse]

i think you need to give more details and some sample raw data. Is the 'last activity' range user selected or a database value or ??? ? Is the billed date a date or a datetime or a number or a string field?

The simplest way would be to use the Select Expert and choose your date field then choose is between and enter the date range there.

 

[rrmcguire]

last activity is a database value from a CUSTOMERS table which is linked to the SHIPMENTS table which grabs the numbers(or record numbers)

So the report displays the records numbers grouped by the Customer ID, the totaled per customer and a grand total of shipment numbers which is working fine.

What I need to do is the user selects an activity date range from the customer table when they run the report(which is through a query generator through our company software)displays only those customers in that date range.

But I need to only show the shipments(different table) for those customers within that activity date range. Being that they're 2 different tables. Im using what would be the BILLED DATE of the shipment. So in a nutshell how to display only those shipments where the BILLED DATE is within the ACTIVITY DATE range.

 

[lbass]

You are describing almost everything instead of showing us. How is the activity date range reflected in the customer table? Two different fields, e.g., begin date and last activity date? Or what? Are they actually date fields? You might be able to simply link on customer and then link also on bill date >= begin date and <= last activity date--if that's how the table is set up.

-LB