Search results for query: *

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

Duane, "when i ask "why is this happening"? why is it that in dbo_account table my account number has leading zeros where in my bsa table it does not? does it have to do with the way i import the data? can you give me an example of an expression in a query that would all the values to match...

Hi Duane, I did what you suggested meaning I queried both tables separately on an account number that exists on both tables. These were my results on bsa table my data type on accountnumber is set to “text” my field size is 16. The account number in the datasheet view is displayed as 12345678...

Hi Duane, My data types for both fields in each table are set to "text". Do you have any other suggestions? Thanks in advance -Jaime

Hi Guys, can anyone tell me why i can not pull all the data from two tables please see below: SELECT Bsa.Nameline1, Bsa.Accountnumber, dbo_Accounts.AccountNumber FROM Bsa RIGHT JOIN dbo_Accounts ON Bsa.Accountnumber = dbo_Accounts.AccountNumber; SELECT Bsa.Nameline1, Bsa.Accountnumber...

Hi Guys, do you guys have any recommendations for good ACCESS books or links with examples of SQL? Thanks in advance