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

Re:weird?

gianluigi

15:02 27 Nov 2008

Re:weird?

[email protected]

15:09 27 Nov 2008

Re:weird?

gianluigi

10:04 28 Nov 2008

Re:weird?

[email protected]

12:11 28 Nov 2008

I now changed ALL fields to "select AS ..."

No difference at all. Are you sure the error is this? I am so sorry, but it does not change anything?

regards Helle

SELECT [tbl_Billed]![BilledID] AS BilledID, [tbl_Billed]![BilledTitel] AS BilledTitel, [tbl_Billed]![BilledInfo] AS BilledInfo, [tbl_Billed]![BilledBeskriv] AS BilledBeskriv, [tbl_Billed]![BilledFil] AS BilledFil, [tbl_StockSites]![StockID] AS StockID, [tbl_StockSites]![StockNavn] AS StockNavn, [tbl_BilledSalg]![StatusID] AS StatusID, [tbl_Status]![Status] AS Status, [tbl_Status]![StatusPix] AS StatusPix, [tbl_BilledSalg]![SalesRelease] AS SalesRelease, [tbl_BilledSalg]![SalesUnique] AS SalesUnique, [tbl_BilledSalg]![SalePrice] AS 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] AS 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]