Forums :: Advanced Search

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Advanced Search

DwZone Forum Index -> Advanced Search

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 101 to 110 of 282 (Total: 122)

First | Prev | Next | Last

Subject

Author

Date

Re:weird?

gianluigi

9:59 27 Nov 2008

Re:weird?

[email protected]

14:41 27 Nov 2008

Hi

This query returns okay names, both in DW and in Access - but not when I use it in Adv Search:

I did try to install version 2.03 and that also made the error, so it is not there the error is?
I use DW CS3, Windows Vista Ultimate, Access 2007

Helle

SELECT tbl_Billed.BilledID, tbl_Billed.BilledTitel, tbl_Billed.BilledInfo, tbl_Billed.BilledBeskriv, tbl_Billed.BilledFil, tbl_StockSites.StockID, tbl_StockSites.StockNavn, tbl_BilledSalg.StatusID, tbl_Status.Status, tbl_Status.StatusPix, tbl_BilledSalg.SalesRelease, tbl_BilledSalg.SalesUnique, tbl_BilledSalg.SalePrice, Sum([tbl_BilledSalg]![SalePrice]*[tbl_StockSites]![StockOmregn]*[tbl_Kurs]![Kurs]) AS SalePriceDK, Format([tbl_BilledSalg].[SalesDato],'yyyy') AS SalesYear, Format([tbl_BilledSalg].[SalesDato],'mm') AS SalesMonth, Format([tbl_BilledSalg].[SalesDato],'d') AS SalesDag, tbl_BilledSalg.SalesDato
FROM Type RIGHT JOIN ((tbl_Kurs RIGHT JOIN tbl_StockSites ON tbl_Kurs.KursID = tbl_StockSites.StockValuta) RIGHT JOIN (tbl_Status RIGHT JOIN (tbl_Billed RIGHT JOIN tbl_BilledSalg ON tbl_Billed.BilledID = tbl_BilledSalg.BilledID) ON tbl_Status.StatusID = tbl_BilledSalg.StatusID) ON tbl_StockSites.StockID = tbl_BilledSalg.StockID) ON Type.TypeID = tbl_Billed.TypeID GROUP BY tbl_Billed.BilledID, tbl_Billed.BilledTitel, tbl_Billed.BilledInfo, tbl_Billed.BilledBeskriv, tbl_Billed.BilledFil, tbl_StockSites.StockID, tbl_StockSites.StockNavn, tbl_BilledSalg.StatusID, tbl_Status.Status, tbl_Status.StatusPix, tbl_BilledSalg.SalesRelease, tbl_BilledSalg.SalesUnique, tbl_BilledSalg.SalePrice, Format([tbl_BilledSalg].[SalesDato],'yyyy'), Format([tbl_BilledSalg].[SalesDato],'mm'), Format([tbl_BilledSalg].[SalesDato],'d'), tbl_BilledSalg.SalesDato