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

    Relocating PDC to another subnet

    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?
  2. jmandiaz

    Relocating PDC to another subnet

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

    Relocating PDC to another subnet

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

    How do i configure/setup OMA

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

    How do i configure/setup OMA

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

    How do i configure/setup OMA

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

    SQL Syntax

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

    SQL Syntax

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

    SQL Syntax

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

    SQL Syntax

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

    SQL Syntax

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

    SQL Syntax

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

    SQL Syntax

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

    Joins (sql)

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

    Joins (sql)

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

    Joins (sql)

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

    Joins (sql)

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

    Joins (sql)

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

    Joins (sql)

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

    SQL BOOKS

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

Part and Inventory Search

Back
Top