Sorting/Viewing Sales Data

[Guest]

Hi all. I need a little help/advice. I've created a property management
database which contains various lease and sales information for over 100
stores. I have a table which contains the following fields: Store No.,
Month, Fiscal Year, Sales.

On the main form of my database, all date type information is based upon the
start date of the store lease. Here's the problem: instead of displaying
sales Jan-Dec, I need to show them based on the Lease year. If a lease
started in August, I need to view monthly sales from August to July. I have
no idea how to achieve this. Can someone help?

Thanks,

D

 

[fredg]

Hi all. I need a little help/advice. I've created a property management
database which contains various lease and sales information for over 100
stores. I have a table which contains the following fields: Store No.,
Month, Fiscal Year, Sales.

On the main form of my database, all date type information is based upon the
start date of the store lease. Here's the problem: instead of displaying
sales Jan-Dec, I need to show them based on the Lease year. If a lease
started in August, I need to view monthly sales from August to July. I have
no idea how to achieve this. Can someone help?

Thanks,

D

Do you really have field's named Year and Month?
Year and Month are reserved Access/VBA/Jet words and should not be
used as field names.

For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

 

[nanne]

easy
create a cross-table query, form or report
showing what you want, only need some trials
success

Nanne