Access 2007 Issue. 2 in 1

[DThib]

Hello all,

I have several databases that hold different segments of an items history. 2 of these databases have parts of the information. I run this in Access and I get a table with my specs.

I need to export the Excel file of this and then attach the database to update the query.
When I first export to start the second part of this process, It gives me NAME?? and it tells me I have an invalid character.

What is going on?
The database queries I am building form work separately.

DThib

 

[xenou]

The most basic sql statements are in the form:

SELECT ....
FROM ....

or

SELECT ....
FROM ....
WHERE ...

But it quickly gets a little more complicated because almost immediately you'll start wanting to involve more than one table and that takes more rules.

There is no requirement about lines being separated. You can use more than one line if you want to, but you don't have too. It's generally more human readable to separate things into multiple lines, but the machine doesn't care.

 

[DThib]

I tried this with same result. I think there is an infinite loop somewhere. I timeout with the same result.
When I try to set up the query in Excel (Add the database query), I get a run-on of rows being added beyond the size of the database constraints.

SELECT [1st_Query].EntryID, [1st_Query].SPR, [1st_Query].ProductGroup_cust, [1st_Query].Product_HW_Disp, [1st_Query].Product, [1st_Query].Summary, [1st_Query].CustomerAccountSAP, [1st_Query].SerialNumber1, [1st_Query].DateSPREntered, [1st_Query].AssignedTo_Name, [1st_Query].SPRStatus, [1st_Query].DateAssigned, [1st_Query].ResolvedDate, [1st_Query].VerifiedBy_Name, [1st_Query].VerifiedDate, [1st_Query].DateClosed, [1st_Query].DaysOpen, [1st_Query].FailureInvID, [1st_Query].Symptom, [1st_Query].AssignedToVerify_Name, [1st_Query].Country, [1st_Query].State, [1st_Query].Complaint_Type, [1st_Query].[Complaint #], [1st_Query].Date_ResolvedBy_MoYr, [1st_Query].Date_OccuredBy_MoYr, [1st_Query].[Function Dept], [1st_Query].ConsoleUsed, [1st_Query].CorrActionReq, [1st_Query].CorrActionID, [1st_Query].DurationOfUse, [1st_Query].[01_dbo_vSPRDetailExtended].DateReadyForFI, dbo_vFI_Data.PrimaryRootCauseLevel1, dbo_vFI_Data.PrimaryRootCauseLevel3
FROM dbo_vFI_Data, 1st_Query
WHERE (([1st_Query].SPR)>"18-");

DThib

 

[Joe4]

If you have two or more data sources in your FROM clause, you usually want to join them based on some field or fields.
Otherwise, it is going to do a Cartersian Product between the two (every single record in Table A is being linked to every single record in Table B). So if you have 1,000 records in Table A, and 1,000 records in Table B, the query would return 1,000,000 records!

Seldom do you ever want a Cartesian product. Usually there is a "relationship" between the two tables that you define in a JOIN clause.
If you look at the link I gave you, and look at the menu items in the left column, jump down to the JOINs for details.

 

[DThib]

Thanks!,
The join I placed has fixed it.

I appreciate the patience and help.

DThib