ACCESS FEED: Re: [MS_AccessPros] Append to table

Senin, 22 April 2013

Re: [MS_AccessPros] Append to table

Hi Duane,
I got it working and SQL view is as follows:
INSERT INTO T_KPI ( PlannedStartDate, JobCount, PercentScheduled, PercentCompleted )
SELECT [Forms]![F_LaundryjobList]![cboPlannedDate] AS PlannedDate, [Forms]![F_LaundryjobList]![text252] AS JC, [Forms]![F_LaundryJobList]![Text260] AS PercentScheduled, [Forms]![F_LaundryjobList]![Text262] AS PercentCompleted;

Earlier, I made a mistake of adding T_KPI in the append query and hence not working/

Thanks and Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Kumar,
>
> We don't generally recommend storing data that can be calculated.
>
> We do recommend providing he SQL view of the query when you ask why the query isn't working ;-)
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > From: access_kri@...
> >
> > Hello all,
> > I have a form where I have various textboxes to display the daily report results. The results are displayed using Dlookup of queries. I want to now save the results/data in a MIS table through a command button.
> > I created a blank MIS table and used append query to add data from MIS form. Somehow, no data is appended to the table. Why?
> >
> > Kind Regards,
> > kumar
>