Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wonderwhy

    Format Date on Form

    No, but it works perfectly! I was trying to put the 'Format' before the field name in the expression. I didn't know to put it at the beginning. Thank you very much! Julia
  2. wonderwhy

    Format Date on Form

    I want to display a date from a subform on my form and format it like: Thursday, May 12, 2005 I currently have it displaying on a text box (like a caption for a subform) using: =[qryFrmSubSleepEpisode]!EpisodeDate but I can't seem to get the syntax right to format it like I want to (above)...
  3. wonderwhy

    Excel Networkdays w/hours and minutes

    Can anyone help me with adding to the formula so that it excludes non-business hours (like from 5PM - 8AM)? Thank you. Julia
  4. wonderwhy

    Parameter in Crosstab Query

    also...why couldn't I do this in the parameter box (choose parameters from the query menu)? I actually did that but it didn't work. Now after adding the sql the parameters also show up in the parameter box. I don't get that, but I'm glad that it is working. Thanks!
  5. wonderwhy

    Parameter in Crosstab Query

    What is the (4)? This worked wonderful, btw. I appreciate your help! Julia
  6. wonderwhy

    Parameter in Crosstab Query

    Thanks, PH. It doesn't matter if I change the names of the formatted/'calculated' fields it still doesn't work. By the way, the parameters in the original query look like this: Like [Enter Year] Like [Enter Month "mmm"] Thanks for any help, Julia
  7. wonderwhy

    Parameter in Crosstab Query

    I've searched and found a million threads with a similar problem, but I can't find an answer that I can understand. Here's the problem: I have a crosstab query to which I would like to add 2 parameters. This crosstab query is based on another (regular) query. The fields to which I want to add...
  8. wonderwhy

    Excel Networkdays w/hours and minutes

    Thank you, Tony. That works great! Here's how my function ended up looking... =NETWORKDAYS(D9,F9,Holidays)-IF(NETWORKDAYS(D9,D9,Holidays)=0,1,MOD(D9,1))-IF(NETWORKDAYS(F9,F9,Holidays)=0,0,(1-MOD(F9,1))) I used a custom format for the cells--> [h]:mm Julia Thanks to John, too! You have both...
  9. wonderwhy

    Excel Networkdays w/hours and minutes

    I will try to get this to work and post back with the results. Thank you, Tony!
  10. wonderwhy

    Excel Networkdays w/hours and minutes

    John (anotherhiggins), It turns out I do need to exclude non-business hours, too. If you have a solution I'd appreciate some help. Thank you, Julia
  11. wonderwhy

    Excel Networkdays w/hours and minutes

    Hello, Does anyone know a fairly simple way to get the number of hours between two dates excluding weekends and holidays? Thanks, Julia
  12. wonderwhy

    Excel Networkdays w/hours and minutes

    Thank you Ilse and John. I tried what you suggested, John. I changed the format of my date fields from mm/dd/yyyy to mm/dd/yyyy hh:ss and then added the custom format to the calculated field of [h]. This made the calculated field show 24 instead of 1 (it had been showing days). But, it is really...
  13. wonderwhy

    Excel Networkdays w/hours and minutes

    I tried to do that, but I haven't been able to figure out how. Where would I do that? Thanks, Julia
  14. wonderwhy

    Excel Networkdays w/hours and minutes

    Hello. I am using the Networkdays function in Excel to calculate the difference between two dates based on working days only (m-f). I am also using a named range called 'holidays' which contains dates which should not be counted. Here's the syntax: =NETWORKDAYS(C10, E10,Holidays) That works...
  15. wonderwhy

    Tab Control Subform

    Thank you, Ken. I will try it and post if I have problems. 'Good day!
  16. wonderwhy

    Tab Control Subform

    Does it work to use a tab control as a form and subform, i.e., will it work to use the first tab as the main form and then a second tab as a subform (with records on the many side related to the first tab)? I've never tried this and just wanted to know if it works. Thanks, Julia
  17. wonderwhy

    Spell Check Problem

    Thank you, Missinglinq! Sorry I didn't say thanks sooner but after no one responded for a few days I stopped checking. Have a great day! Julia
  18. wonderwhy

    Spell Check Problem

    Hello, I'm sure there is a real simple solution to this problem. I am trying type the acronym CNA (certified nursing assistant) into a form and spell check keeps changing it to CAN. I haven't found a way to add CNA to the dictionary. What's the solution? Help. Thank you, Julia
  19. wonderwhy

    Checkbox Checked with Enter Key

    Wow. Do I feel stupid! Thanks a bunch.
  20. wonderwhy

    Checkbox Checked with Enter Key

    Hello, How can I make a checkbox be checked when a user tabs to it and presses Enter rather than using the mouse? If this works then I wouldn't I have to somehow make it so that using the enter key didn't do the same thing as the tab key? Any great ideas to allow checking a checkbox without...

Part and Inventory Search

Back
Top