Search:

Type: Posts; User: Maggie Barr; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    175

    Re: Hyperlink Problem, please help.

    Yongle,
    Thank you for sticking with me. It is a typical website I want to open, actually A LOT of them, but one is https://ebird.org/atlasme/block/47068A8NW but instead of opening it all the way,...
  2. Replies
    4
    Views
    175

    Re: Hyperlink Problem, please help.

    Yongle,
    Thank you for getting back to me. The workbook was created in excel 2019, and I already created another workbook and pasted the link address, re-activated it, and it did the same thing. I...
  3. Replies
    4
    Views
    175

    Hyperlink Problem

    Hello and thank you in advance if you can help,
    I am using excel 2019 64 bit on a PC.

    I have a VBA macro that I have used to create hyperlinks in the past. It has always worked fine, and it...
  4. Re: Access Query Expression Builder Concatenate IIF syntax, formula help?

    welshgasman,
    I know nothing about writing functions. I just googled it, and it is indeed quite interesting. So, from what you are saying, I could write a function (VBA?) within my query to populate...
  5. Re: Access Query Expression Builder Concatenate IIF syntax, formula help?

    welshgasman,
    Thanks for the note, I was just going to post how I resolved my issue. It is not the prettiest way, and I am sure there is probably some beautiful elaborate formula that would get me...
  6. Access Query Expression Builder Concatenate IIF syntax, formula help?

    Hello and thank you in advance if you can help,
    I am trying to create a column in a query that compiles/concatenates information from other columns when certain criteria are met. The problem I am...
  7. Re: Expression builder syntax, if not null then...

    xenou,
    It actually does work for the cases where the Start_Date_Value is null, it leaves the output cell blank, which is exactly what I want it to do. My first formula made no reference to if the...
  8. Re: Expression builder syntax, if not null then...

    xenou,
    Sorry for any confusion I may have caused. Below is the code for exactly what I need, and it works (I tested it), and I only have to click on the cell in the column I inserted within my...
  9. Re: Expression builder syntax, if not null then...

    stumac,
    Thanks for your reply. I had to write in the query reference as there is another query within the query with the same field name. I can, and will, update it to the better form.
    Thanks,...
  10. Re: Expression builder syntax, if not null then...

    I actually did account for leap years, it is 1-366.
    What I am trying now is:
    OBS_DATE_ACCEPTANCE: IIf([eBird_ALL_DATA Query2 Base Data Output.START_Date_VALUE]+[eBird_ALL_DATA Query2 Base Data...
  11. Re: Expression builder syntax, if not null then...

    Sorry, but I don't see how the syntax is invalid as it worked in my first formula just fine.
    IIf([eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]<[eBird_ALL_DATA Query2 Base Data...
  12. Re: Expression builder syntax, if not null then...

    xenou,
    I am sorry if I didn't make it clear, the "values" for dates are just numbers, 1-365. there is no actual date comparisons. I set it up this way to that each Day-Month has a numeric value,...
  13. Re: Expression builder syntax, if not null then...

    xenou,
    DAY-MONTH_VALUE, is an observation date, never blank or null
    START_Date_VALUE, if it is blank so is END_Date_VALUE, no value present for non state species.
    So, I would like the formula to...
  14. Re: Expression builder syntax, if not null then...

    xenou,
    Thank for the response. The Start_Date_Value is a field that is a numeric value for a Day-Month combination for acceptable species in our state from a lookup table, so it is just loaded as a...
  15. Expression builder syntax, if not null then...

    Hello and thank you in advance if you can help,
    I have a column I created that works great:
    IIf([eBird_ALL_DATA Query2 Base Data Output.DAY-MONTH_VALUE]<[eBird_ALL_DATA Query2 Base Data...
  16. Re: Filtered Query not staying filtered when brought into another query?

    xenou,
    Thanks for the response. Below is the SQL for the query I was trying to use the "valid" field from. I am sure it is a rookie maneuver, but I have no idea what. If I could learn how to do...
  17. Access Query expression builder error, please help.

    Hello and thank you in advance for helping if you can,
    I have an expression for building a calculated column in an Access query that has worked fine in the past, but I am trying to do it know, and...
  18. Re: Filtered Query not staying filtered when brought into another query?

    Solved.
    Well, for some reason when I brought in the field I had created in the valid records query to point to "VALID" records in hopes to filter on that, it would apply "VALID" to the whole record...
  19. Filtered Query not staying filtered when brought into another query?

    Hello and thank you in advance if you can help,
    I am using Excel 2019 on a PC. I am still quite new to Access, so I would appreciate any guidance to resolve this issue I am having, and I will...
  20. Re: Access Query won't run, getting error.

    xenou,
    I made another access database, went in my original, and used a make table query on the base query I had that had already brought in fields from multiple lookup tables, and I linked to that...
  21. Re: Access Query won't run, getting error.

    xenou,
    I bring my files into the database by using the "Link to the data source by creating a linked table.". That way I can import a lot of tables (text files & excel) without maxing out the...
  22. Access Query won't run, getting error.

    Hello and thank you in advance if you can help,
    I am using Access 2019 on a PC.
    I have a database that under properties is said to have a size of 2.87 MB. All my files are linked, four data...
  23. Re: Can't get new measure based off other measures in Power pivot to work, please help.

    Macfuller,
    Last update, but I felt I should post it.
    So, I am a humble person in general, but it is with great humility that I share how I finally did this. As it turns out, I placed the common...
  24. Re: Can't get new measure based off other measures in Power pivot to work, please help.

    Macfuller,
    Well, I didn’t get to accomplish my goal with a measure, but I did get it done the “dirty” way. I made two reference queries off my full data query. In the first I did a series of...
  25. Re: Can't get new measure based off other measures in Power pivot to work, please help.

    macfuller,
    You are right about the merged fields. I have already created a series of merged fields I use that let me create my DISTINCTCOUNT measures. For the numerator I created a measure that is...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4