Search results

Thanks - I was missing the connection there for a few minutes that ":" is like a "=". Russ

My query has sums i need to subtract from a fixed number and have of the report. New field (name=balance) = fixed number (12) minus column b and column c. I am having trouble getting the expression to work, I get prompted for the balance. Any help is appreciated. Attached is a screen print...

Never mind - Duh - the < should be >

I want records less than 180 days old. I coded it up as <Date()-180 But it does not work. Any ideas for improvement? A picture of the query is attached to look at. Thanks Russ rneuman at scaninc.org

Re: query - criteria based - Working :DAdam - I think I got it working!! That is a pretty heavy expression for a beginner: TIME-SA2: Round(IIf([ACTIVITY TYPE-SA]<>"Travel",[TIME-SA],"0"),2) Thanks for help. Russ

Adam - Thanks. Russ

Can you make the a rounded number now? See my jpeg. Thx Russ

Adam - you are smart. I am almost there now. Russ

I would like this field TRAVEL TIME VALUE: [Export_Data]![TIME-SA] to be zero un-less another field Activity Type_SA is eqaul to "Travel" Anyone know how could I code this??? attached is a screen image of the query Thanks in advance. Russ rneuman@ SCANINC.org

Thank you Russ

I need to get a count of the number unique of females and males on my db. I have first name, last name, gender. So, I need to merge those fields (first name, last name) and carry the gender through with the merge to get a count. How would I code this up in a query? Thx Russ Rneuman @...

Thanks Paul - I will keep adjusting and update the forum as I hopefully get it correct. Russ

Paul - I am tried it and got a syntax error. "Expr1: Round(Sum([Time-SA]),2)" can you please advise a minor change I did attached a screen print for helping on the resolution. Thanks Russ

Yes it did not seem to work easily with the sum function: I put this in the expression: = ROUND ( [SumOfTIME-SA] , 2) Then I get prompted for the value SumofTIME-SA The sum of field TIME-SA is what I want rounded. Thanks Russ

There does not seem to be a simple, obvious way, to round you output of a query: I am getting numbers like this: 25.3175999112427 And rather have a number like this: 25.32 Sometimes I am doing a sum on a field. Or if I am just query dumping a field. I need a simple format process for output...

If you do install the VB code remember to drop the comments in the front I did not and caused my Switchboard to crash. The words before "Public Function": "- Calculating a person's age in years, months and days To accurately calculate a person's age in years, months and days, and...

Re: Un-edit-able Switchboard - FIXED :) I found the problem. I had some bad VB code. That caused the edit of the switchboard to fail. I had some extra comments in front of the VB code. I removed them and all is running smooth. The Switchboard had not worked for 3 months since I installed...

Re: Un-edit-able Switchboard?? - reply#2 It happens when I - click Database Tools - Switchboard Manager - select the name (default) switchboard - and click Edit. The exact error message is at the URL http://www.box.net/shared/713zefoltg I did a screen print of it. Thanks for the quick...

MS-Access 07 - It displays ugly. I try to edit the swithbox and the pop-up message happens: "Compile error, in query expressing 'IIf(IsNull [Arguement]),"',([Arguement])" And that is it. No editting allowed?? How can I patch up the current switchboard or must I trash it and start all...

Is that option that was in 2003 still available ? Russ at Scaninc.org