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...
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!
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.
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.
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?
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...
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...
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...
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.
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?
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?
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.