Re : pb avec le nom d une requete
bon j ai finalement trouve le SQL de la requete
Query: Qry - convert all prices to USD Page: 1
Properties
DateCreated: 19/02/2008 16:21:16 DefaultView: 2
DisplayViewsOnShare 1 DOL: Long binary data
FilterOnLoad: False GUID: {guid {52BD5DE5-
274D-4D9B-A455-
HideNewField: False LastUpdated: 13/10/2009 15:40:30
MaxRecords: 0 NameMap: Long binary data
ODBCTimeout: 60 OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
RecordLocks: No Locks RecordsAffected: 0
RecordsetType: Dynaset ReturnsRecords: True
TotalsRow: False Type: 0
Updatable: True
SQL
SELECT [Lnk - TecTrade Generated Data].[Document #], [Lnk - TecTrade Generated
Data].[Document Date], [Lnk - TecTrade Generated Data].[Customer Code], [Lnk -
TecTrade Generated Data].[Customer Name], [Lnk - TecTrade Generated Data].Total,
[Lnk - TecTrade Generated Data].[Item Code], [Lnk - TecTrade Generated Data].[Item
Name], [Lnk - TecTrade Generated Data].Quantity, [Lnk - TecTrade Generated
Data].Unit, [Lnk - TecTrade Generated Data].[O/S Quantity] AS Expr1, [Lnk - TecTrade
Generated Data].ETD, [Lnk - TecTrade Generated Data].[Unit Price], [Lnk - TecTrade
Generated Data].[Outstanding Amount], Round(IIf([Lnk - TecTrade Generated
Data]![Last Purchase Price Currency]="USD",[Lnk - TecTrade Generated Data]![Last
Purchase Price],[Lnk - TecTrade Generated Data]![Last Purchase Price]/7.75),2) AS
[Last Purchase Price USD], Round(IIf([Lnk - TecTrade Generated Data]![Last Selling
Price Currency]="USD",[Lnk - TecTrade Generated Data]![Last Selling Price],[Lnk -
TecTrade Generated Data]![Last Selling Price]/7.75),2) AS [Last Selling Price USD],
Query Parameters
Name Type
[Lnk - TecTrade Text
Generated Data].[O/S
des pistes ?
merci beaucoup