User Profile

Collapse

Profile Sidebar

Collapse
nlsmith326
nlsmith326
Last Activity: Feb 28 '09, 12:05 AM
Joined: Apr 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Default Value on SubForm Tab Page #2 from Main Page Tab #1

    Greetings!

    Was wondering if anyone out there had any suggestions for setting a default value.

    I have one main form w/ tabs & subforms. What I've been trying to do (unsuccessfully ) is set a default value in the subform on one tab as the value provided on the main from on the first tab.

    I was able to put this string together, but everytime I check my form, the value doesn't display...
    ...
    See more | Go to post

  • nlsmith326
    started a topic Count multiple categories for Reports

    Count multiple categories for Reports

    Greetings,

    I have a table set up w/ the following fields (excerpt):
    PartType1
    PartType2
    PartType3
    PartType4
    PartQuantity1
    PartQuantity2
    PartQuantity3
    PartQuantity4

    For every specific part that is entered, there must be a quantity.

    On my report I would like to total the quantities of parts entered by the individual part name.

    I'm...
    See more | Go to post

  • nlsmith326
    replied to Count in Access
    I have a similar question, how can I run a SUM in a report if I to count by a combination of fields? Here's the code I've been using, and I keep getting an #Error....

    =Sum(IIf(([Age]>"18",1,0)) and ([Searched]=-1,1,0)))

    Many thanks,
    ~Natalie...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...