Recent content by clubdjlouie

Note that Query 1 feeds into 2 and 3 feeds into 4 It acts as a prefilter of some sort. we had to match it in one table, get the results of that and match those results to another table to call up the match in the third table.

I GOT IT!! My boss and I (who neither of know anything about Access) sat down for 3.5 hours and finally got it working. In order to do get it to work, I had to have 4 queries. 1-->2 for Server and 3-->4 for Domain (note that Query 2 depends on 1 and 4 depends on 3) Server Query part 1...

Well I give up. I appreciate all your help. I still can't get this to work and am burnt out on the whole thing. I really appreciate your time though

I have never used access before and i hope not to ever have to do anything more complicated than this in the future. I searched the net and found nothing but access training courses. This query asks me for the 30PPaper data? it should be asking me for Table1 server, domain SELECT...

I'm sorry, but even that simple sql code doesnt work on access Select cols From table1, tableXref, table2 WHERE table1.server = tableXref.Server AND tableXref.id = table2.ID I plugged my names into it Select cols From SERVERS, 30PXReF, 30ppaper WHERE 30ppaper.server = 30PXReF.Server AND...

So far I can relate to everything but "Select cols" ? yes I am that thick

I do not wish to take up any more of your time, maybe if we simplifed everything Table1 server, domain Table2 id, data TableXref server, domain, id How do I do a simply query to match table1 to TableXref to obtain the id? I will be doing two queries since to make sure that I checked for id...

SELECT [30PXREF].Domain, [30PXREF].ID, [30PXREF].Server, [30PPAPER].ExceptionType, [30PPAPER].ApproveDate, [30PPAPER].GenericIDs FROM SERVERS INNER JOIN (30PPAPER INNER JOIN 30PXREF ON [30PPAPER].ID = [30PXREF].ID) ON (SERVERS.Server = [30PXREF].Server) AND (SERVERS.Domain =...

I took your advice and simplifed most of the table names 30P Paper Reconciliation Data --> 30PPAPER 30P_XRef_Server_Name --> 30PXREF Generic ID(s) --> GenericIDs Exception Type --> ExceptionType Approve Date --> ApproveDate I can't change "Server Information" table name, too much...

Is it possible that the complicated table names/fields could be messing up my query?

Good idea, didn't think of that. SELECT [30P_XRef_Server_Name].Domain, [30P_XRef_Server_Name].Server, [30P Paper Reconciliation Data].ID, [30P Paper Reconciliation Data].[Generic ID(s)], [30P Paper Reconciliation Data].[Exception Type], [30P Paper Reconciliation Data].[Approve Date] FROM...

It still returns no data! here is what I have... a query named show xrefs at the top I have ID joined with ID in Equijoin mode in the query I tried what you said to relate a query that looks for forms!theform!server Query looks like this... Field: Domain Table: XRef Sort: <blank> Show...

wow, that is confusing. Does it make a difference whether I set the join at the query level or at the main objects screen of access? I note that if I set them in the queries, they do not affect what is in the when I click the Relationships button.

I have been pounding my head against the wall trying to figure out why this doesnt work! It's so simple yet I do not know how to do this? Any help would appreciated... Microsoft Access Database I have three tables... Table A : &quot;Servers&quot; Fields : Server, Domain Table B ...