AnsweredAssumed Answered

Retrieve data by date

Question asked by mayor on May 13, 2009
Latest reply on May 19, 2009 by mayor

Title

Retrieve data by date

Post

Hello,

 

I facing a problem how to search the data by month anda year.

I got 2 tables, research anda expenses

 

Research ( research_account_no, researcher_name, amount ....)

Expenses (research_account_no, invoice_no, invoice_date ....)

 

Relational field : research_account_no

 

I have created 1 layout based on invoice_date, but how to retrieve data by monthly and yearly, based on invoice_date.

How to do that? Please advice me.

 

TQ

Outcomes