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!

  • Congratulations gkittelson 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. JeremyAnderson

    Querying queries

    SCORE!! I found it... replaced the Count(IIF(currdayslate>0,custnum,o)) with a Sum(IIF(currdayslate>0,1,0)) and it worked! This project is really starting to come together. I am so greatful to all of you for your insight. I am in no way a database guy. Actually, my specialties are...
  2. JeremyAnderson

    Querying queries

    Thank you all for your insight on this! PHV that SQL statement worked for the most part, however the last count if statement isnt working. I am looking into that now, but thank you very much for giving me a wonderful starting point!
  3. JeremyAnderson

    Querying queries

    And no I really dont want to have to enter the userid each time. I would like to be able to only enter it once for the query and have it pull all the results for each of the 3 original queries.
  4. JeremyAnderson

    Querying queries

    Actually it will be used by a Macro to query from the linked table and place it in local table named the same as the userid. Reports will enevitably be ran from the local tables but right now I am focussing on getting the data where it needs to be.
  5. JeremyAnderson

    Querying queries

    ALso each of the queries prompts for a userid to search for within the table. Is there a way to script this query so that it only prompts once but finds all values based on that user id?
  6. JeremyAnderson

    Querying queries

    The first is: SELECT Sum(dbo_LoanViewAll.currbalamt) AS SumOfcurrbalamt, Count(dbo_LoanViewAll.custnum) AS CountOfcustnum FROM dbo_LoanViewAll WHERE (((dbo_LoanViewAll.collectoruserid)=[Enter User ID])); the second is: SELECT Sum(dbo_LoanViewAll.currbalamt) AS SumOfcurrbalamt...
  7. JeremyAnderson

    Querying queries

    Thank you very much Leslie! That worked, however is it possible to get them to display in the same record like: Query 1 Data | Query 2 Data rather than as 2 seperate records like: Query 1 Data Query 2 Data The end result of this query will be a macro which copies the output of the query to...
  8. JeremyAnderson

    Querying queries

    Ok I have been told that you can preform queries to pull data from multiple other queries in MS Access. I have tried this and keep getting an error stating that I am attmepting to pull info from both a query and the table it relates to. This is not the case however. I have 2 tables one has...
  9. JeremyAnderson

    Macro Question

    Also: Is it possible to create a report based on multiple queries? If so how, as I have been unable to do so. Sorry for the basic questions. I just am very unfamiliar with Access.
  10. JeremyAnderson

    Macro Question

    Thank you very much!!! That worked beautifully. Next Question: Im doing a query as part of this macro and I need it to prompt the user for a date range to query against. What should i use as the criteria for the query?
  11. JeremyAnderson

    Macro Question

    Ok so I writting my frist Macro in Access and I want it to auto respond to all pop ups with Yes. How would I do this?
  12. JeremyAnderson

    SQL to Access question

    I am attempting to pull data from a remote SQL server and filter it to append certain records to differant tables in a local Microsoft Access database. Anyone know how to do this?
  13. JeremyAnderson

    Excel and SQL Queries

    I have done this in the past to pull data from the same table, however, it will not allow me to pull from multiple tables as they are not linked or related on the Server side. I apologize that I had not included this information before.
  14. JeremyAnderson

    Excel and SQL Queries

    I have a problem that I hope someone can help me with. I need to query multiple tables in a SQL DB from an Excel Spreadsheet with a single query. Here some background information on the issue: I work for a franchise store of a larger used car dealership. Each franchise and the corporate office...
  15. JeremyAnderson

    SQL, ODBC, and MS ACCESS

    Awesome, so now all I need to know is how to link certain columns in the SQL db to certain columns in the Access db. ANy ideas??
  16. JeremyAnderson

    SQL, ODBC, and MS ACCESS

    Ok I am new to the Database world and need some advice. I am creating an MS Access database using Office XP. I need to pull data from a remote SQL database. I have setup a connection to the database via ODBC Data Access Adminstrator, and can pull data from the SQL db to an Excel doc, but how...

Part and Inventory Search

Back
Top