+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, MS Access - Subform, Filtered by date then grouped by category in Technical; I've been working on this for the past few nights and cant seem to make it work, if anyone can ...
  1. #1

    Join Date
    Jan 2013
    Posts
    25
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    MS Access - Subform, Filtered by date then grouped by category

    I've been working on this for the past few nights and cant seem to make it work, if anyone can offer any guidance I would be grateful.

    Table: Transactions: ID,Date,Title,Category,Value, Budget Name
    Table: Budget: Budget Name
    Budget Years: Budget Name, Date From, Date To

    Form entitles Budget, Fields : Date From, Date To, Budget Name

    So within the form budget I have a subform which I want to group the categories and get a total value. THE tricky part is, I only want it to include values from the budget specified in the form and the date range of the form.

    Tweaking my approach, I can do one or the other but not both!

    Thanks.

    Steve

  2. #2

    Join Date
    Feb 2011
    Location
    Dudley
    Posts
    120
    Thank Post
    18
    Thanked 32 Times in 22 Posts
    Rep Power
    13
    Any chance you can share your database.. It's hard to understand exactly what you're trying to do from your description... Specifically I am not clear on what the Budget Years table represents and what fields from which tables are included in your form/subform. Also, is the form for data input or just for search and display records?

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Filtering SIMS reports by User Defined Groups
    By jacqui136 in forum MIS Systems
    Replies: 5
    Last Post: 28th February 2014, 11:24 AM
  2. Formatting auto date in MS Access Reports
    By RabbieBurns in forum Windows
    Replies: 4
    Last Post: 24th June 2008, 02:41 PM
  3. MS Access
    By wesleyw in forum How do you do....it?
    Replies: 1
    Last Post: 9th November 2006, 09:50 AM
  4. Profile to allow just MS Word and MS Access
    By mattpant in forum Windows
    Replies: 17
    Last Post: 12th October 2006, 03:06 PM
  5. ms access request for help
    By rama1712 in forum Windows
    Replies: 1
    Last Post: 6th October 2006, 01:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •