Search:

Type: Posts; User: paweaver; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    272

    After a good nights sleep and your comments. The...

    After a good nights sleep and your comments. The answer is..
    Seems to be a very creative way to have both a Calculated Field AND a Running Total in a Report.
    Used in a calculation [text226] =...
  2. Replies
    3
    Views
    272

    What is the TEXT command

    I found this in a report and needed to know what it does?
    IIf(IsNull([COST]),"",[text221])
    What does this do? [text221]
  3. Thread: Running total

    by paweaver
    Replies
    2
    Views
    290

    Added sample file

    This is a sample file of the Excel spreadsheet of the formulas and what the expectations are.
  4. Thread: Running total

    by paweaver
    Replies
    2
    Views
    290

    Running total

    variables given
    BeginYear
    NoYears
    Cost
    Fvrate
    rate2

    Formulas:
    FutureValue: cost * (1+Fvrate)^NoYears
    PresentValue: FutureValue / (1+ rate2) ^NoYears
  5. Replies
    10
    Views
    1,304

    new challenge. create a blank database and...

    new challenge. create a blank database and imported tables only. The query above now works.
    At the step of creating a FORM ......then put a combo on a form with a RowSource of qryTables. ..........
  6. Replies
    10
    Views
    1,304

    I get a compile error with the SQL.. I'm using...

    I get a compile error with the SQL.. I'm using 2010
    30777
  7. Replies
    10
    Views
    1,304

    using the SQL code

    please help me here.
    Not sure how to accompish the first task. Not sure where to put the code. Select.. Seems where ever I put it does not work. So could it be the code or whre i'm putting it. ...
  8. Replies
    10
    Views
    1,304

    A form to ask for the table

    Any helpful hints or recommendations to accomplish the task suggested?
  9. Replies
    10
    Views
    1,304

    Query from multiple tables

    Data comes from a propriatry source. It can be exported to Excel. Then it is imported into Access. Currently ther are over 70 individual tables. All tables have the same number of fields, alot. We...
  10. Replies
    16
    Views
    6,619

    so thankful for your previous help.. Another...

    so thankful for your previous help..
    Another issue with   everywhere..
    STUDENTS MUST BRING SEWING MACHINE. Textbook and/or Supplies Required.Click here for Book/Supply...
  11. Replies
    16
    Views
    6,619

    on eof those embarissing moments . I had the code...

    on eof those embarissing moments . I had the code working in a teat database. however, i cannot get it work onthe client machine. I created the module in VB.
    Public Function StripHTML(zDataIn As...
  12. Replies
    5
    Views
    1,006

    you know there would be a twist and you guys were...

    you know there would be a twist and you guys were right. They only want to combine if it is M,T,W,TH,F, ONLY for that one. also, it would appear that the field schdaysofweek could come from...
  13. Replies
    16
    Views
    6,619

    intersting that it works really well.

    intersting that it works really well.
    <a target="_blank" href="http://www.bpcc.edu/workforcedevelopment/documents/campcavswaiver.pdf"><b><font color="#921f30">Click here for Camp CAVS Summer Camp...
  14. Replies
    4
    Views
    835

    me too

    I just tried it on another databse and it worked as well. thanks for the help
  15. Replies
    4
    Views
    835

    using the IIF formula

    I tried that formula. However, only the true part works, ie Start date.
    what does not work is the false part. for some reason it displays nothing. Seems it is being confused by 2 date fields and the...
  16. Replies
    16
    Views
    6,619

    What version of Access are you using? 2010

    What version of Access are you using? 2010
  17. Replies
    4
    Views
    835

    combine date if conditions are met

    I tried some code like this in a query using IIf
    If [StartDate] = [EndDate], Then just print [StartDate], else [StartDate] "thru" [EndDate]
    It just displays a null field.
  18. Replies
    16
    Views
    6,619

    sample data that is in the field

    <p>Twist, fold and loop wire to create an Alexander Cader inspired animal out of clay and wire. Explore various techniques for bending and manipulating wire while having fun! Registration in a Camp...
  19. Replies
    5
    Views
    1,006

    Combine text based on a condition.

    The data for the table comes from an OCDB database out of our control.
    for a field named DaysofWeek it list all of the days based on the days that were selected.
    for example. If the input was...
  20. Replies
    16
    Views
    6,619

    Convert HTML into plain text

    The data for the table comes from an OCDB database out of our control.
    Need code to strip the HTML code from the field Course so that in our query it will appear as plain text.
Results 1 to 20 of 21