I m using MS Acces 2007, I need to create a form through which a user can enter all the parameter values in the form and these values will automatically picked by a query:
Here is the query which i want to link with a form
Expand|Select|Wrap|Line Numbers
- INSERT INTO [DSF Daily Activity Query mode] ( [Code:], [Month:], [Date:], [Cont Made], [Appt Made], [Appt Atten], [No of PFRs], Cases, Premium, [Rept Mgr Code:], [Rept Type:] )
- SELECT [DSF Daily Activity 1].[Code:], [DSF Daily Activity 1].[Month:], [DSF Daily Activity 1].[Date:], [DSF Daily Activity 1].[Cont Made], [DSF Daily Activity 1].[Appt Made], [DSF Daily Activity 1].[Appt Atten], [DSF Daily Activity 1].[No of PFRs], [DSF Daily Activity 1].Cases, [DSF Daily Activity 1].Premium, [DSF Daily Activity 1].[Rept Mgr Code:], [DSF Daily Activity 1].[Rept Type:]
- FROM [DSF Daily Activity 1]
- WHERE ((([DSF Daily Activity 1].[Date:]) Between [From Date ] And [To Date])) OR ((([DSF Daily Activity 1].[Code:])=[Enter Code]));
My form name is "Data Entry"
Please help me to resolve this problem.