Recent content by jmandiaz

Elmurado, the sentence of your posting reads "A Windows Small Business Server 2003 domain can have no more than 75 CALs. You can use CALs for each user or for each device". So does that mean that once my company reaches 75 employees exchange will need to be migrated to win2k3 standard edition?

Thank you theravager and 58sniper. the server is windows 2003 SBS. i do have additional DC. I'm schedule to the move in about two weeks. I will keep you posted. Thanks again guys. -Jaime

Hello everyone, I currently have a PDC in 172.21.178.0/24 subnet I plan on moving the PDC to 172.21.216.0/24 subnet Is there anything I have change other than the IP and update the AD sites? Please advice Thanks in advance -Jaime

Marc, thanks for your response. I will take a look at the link you reference. Thanks again. -Jaime

Hello Everyone, Can someone please point me in the right direction. I'm trying to configure-setup Outlook Mobile Services. However when i attempt to add the mobile carrier (verizon there's a field that contains smtp domain. How do i go about attaining a domain? do i have to purchase the service...

Hello Everyone, Can someone please point me in the right direction. I'm trying to configure-setup Outlook Mobile Services. However when i attempt to add the mobile carrier (verizon there's a field that contains smtp domain. How do i go about attaining a domain? do i have to purchase the service...

dhookom you are the man! that's EXACTLY what i was looking for. Thanks again

Hi dhookom, my records are coming from a trasaction table. The transaction is setup with the following colums/fields Businessdate|Acctnumber|Cashin|Cashout|Checktotal|Reversed let's say i walk in to jaime's bank. I make a deposit for my business account for 2k. The system takes my deposit as...

Dhookom, thanks for your queries all the examples giving returned data but it's not the output i was looking for. Do you any other suggestions. Thanks in advance -Jaime

dhookom, i want the outpput to be displayed like SumOfCashIn SumOfCashOut $40,000.00 $15,443.02 $0.00 $10,215.62 $0.00 $3,661.78 $0.00 $8,290.00 $0.00 $9,814.51 $0.00 $6,779.00 $106,317.60 $0.00 $5,605.00 $0.00 $5,007.00 $0.00 $6,403.00 $0.00 $3,260.00 $0.00 $8,350.00 $0.00 $4,300.00...

dhookom, okay cashin is one column, cashout, is another column, let say i have several businesses each business is has it's own acctnbr. through out the day i make deposits and withdrawels from each of the accts. Let say i come in make i deposit for 1k at 10 a.m. i come in at 12 p.m and make...

dhookom i'm sorry for being vague. I would like for the query to return acctnbr|cashin|cashout 1234567 3000 50000 7890101 7000 4000 How can i accomplish this? Thanks again. -Jaime

Hi guys, i have a table named transactions the table has the following fields businessdate, calendardate, acctnbr, cashin, cashout. i'm trying to query all acctnbrs that have the sum of cashin and cashout >= 3000. What would the syntax be to return the data i'm looking for. Please advice and...

Duane, Thank you very much for your help on this. What i ended up doing was exporting the table into excel and then converting the column to a number and re-importing it back into access. I'm sure like you mentioned i can also do this via an expression at this time however i want to see if can...

Duane, I apologize for not being specific with the question and being vague on it. Let me try to make myself a bit clearer. This is what I’m trying to accomplish. I have two systems one of the systems is using a mainframe and the other system is using SQL Server 2000. Both systems produce...