Saya sudah coba-coba ternyata setelah pelajari Function di SQL Server 2008 (
express R2 ) solusinya
1. Buat function
ALTER FUNCTION dbo.FunctionParameterTanggal
(@BeginningDate datetime,
@EndingDate datetime)
RETURNS TABLE
AS
RETURN ( SELECT TOP 100 PERCENT dbo.Orders.ShippedDate,
dbo.Orders.OrderID, dbo.[Order Subtotals].Subtotal,
YEAR(dbo.Orders.ShippedDate) AS Year
FROM dbo.Orders INNER JOIN
dbo.[Order Subtotals] ON dbo.Orders.OrderID =
dbo.[Order Subtotals].OrderID
WHERE (dbo.Orders.ShippedDate IS NOT NULL) AND (dbo.Orders.ShippedDate
BETWEEN @BeginningDate AND @EndingDate)
ORDER BY dbo.Orders.OrderID )
2. Isi di Report property RecordSourcer
Me.RecordSource = "select * from FunctionParameterTanggal(" &
sBeginningDate & "," & sEndingDate & ")"
dimana sBeginning dan sEndingDate berformat 'YYYY-MM-DD'
Baca juga buku karangan Hear Talib untuk lebih memahami Access dan SQL Server.
Terima kasih terutama Master Access Haer Talib.
--- In [email protected], "jkssbma" <jkss...@...> wrote:
>
>
> Saya melakukan upsizing northwind.mdb . Ada beberapa kendala .
>
> Pada Form Order terdapat kode :
>
> strDocName = "Invoice"
>
> DoCmd.OpenReport strDocName, acViewPreview, "Invoices Filter"
>
> Dimana Isi Function Query Invoices Filter :
>
> SELECT dbo.Invoices.* FROM dbo.Invoices WHERE
> (OrderID = @intFormOrdersOrderID)
>
> Persoalnya kode aslinya ( access 2003 Query Invoices Filter )
>
> SELECT Invoices.*
> FROM Invoices
> WHERE (((Invoices.OrderID)=[Forms]![Orders]![OrderID]));
>
>
> Saya tak tahu apakah karena Access 2010 tak mendukung penggunaan control
> component sebagai parameter pada Query .
>
> Persoalannya bagaimana mengkaitkan nilai ( [Forms]![Orders]![OrderID])
> ke parameter pada Query (intFormOrdersOrderID) ?
>
> Terima kasih
>
