Sorting/Viewing Sales Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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'
 
easy
create a cross-table query, form or report
showing what you want, only need some trials
success

Nanne
 
Back
Top