Search results for query: *

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

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)...

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

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!

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

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

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...

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...

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

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

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

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...

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

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...

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

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

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

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

Wow. Do I feel stupid! Thanks a bunch.

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...