Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Help (Access 2000)

    Hello,

    I am new to this forum. I Now that I can't access the MS groups from work anymore, I went looking for a web based group. I was sent her from PC 911.


    Here is my question:

    I have a query that I want to create a field that will give me a date that is 2 days later than the dttStartDate. I thought the below calculation would work but it didn't. As you can probably tell, I am not a programmer and don't do computer stuff for a living <img src=/S/confused.gif border=0 alt=confused width=15 height=20> but I do keep trying. <G>

    In the Field: Row I typed "Tag Date: *<3>" without the quotes.

    I copied that from another query in a database wizard an hoped it would work....it didn't <G>

    I would also like to make this a parameter query and once I get the right calculation/function/expression, I would like to put in the criteria so the user can type in a date and only the records for that date would show up.

    Thanks,

    Linda

  2. #2
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Help (Access 2000)

    Hey, thanks Hans!....I was kind of close...Not sure why I used * instead of +. I must have been thinking too hard. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    I have a bunch more questions so I'll be back.

    Linda

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Help (Access 2000)

    Hello Linda, welcome to Woody's Lounge!

    In an empty column, type the following expression in the Field: row:

    TwoDaysAfter: [dttStartDate]+2

    You can replace TwoDaysAfter by whatever caption you want the calculated field to have. if you want to have a parameter for this (or another) field, enter a prompt between square brackets [ and ] in the Criteria: row, for example:

    [Enter_Date]

    Feel free to post back if you need more assistance.

Posting Permissions

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