I'm trying to edit the data in the ConfigF Text box in my form but I can't. I need to make the configF editable and be able to pull Monday thru Sunday. This is the procedure I have.

ALTER PROCEDURE test
(@v_acid int = '201')
AS SELECT DISTINCT
s.id,
a.tailnum,
s.sched,
s.dadate,
s.config,
f.config AS configF,
f.acid,
DATENAME(dw, s.dadate) AS strdate
FROM dbo.sched s
JOIN dbo.aircraft a ON s.acid = a.id
JOIN dbo.flysheet f ON s.acid = f.acid AND CONVERT(VARCHAR, f.dadate, 101) = CONVERT(VARCHAR, s.dadate, 101)
--JOIN dbo.flysheet f ON s.acid = f.acid AND DATEDIFF(d, f.dadate, s.dadate) = 0
WHERE (f.acid = @v_acid)
ORDER BY s.dadate

This is how the data is being pulled:

id tailnum sched dadate config configF acid strdate
254046 3816 SP 24-Oct-05 C23FM 201 Monday
254048 3816 SP 26-Oct-05 C20FM 201 Wednesday
254049 3816 FLY 27-Oct-05 C20FM 201 Thursday
254050 3816 FLY 28-Oct-05 C20FM 201 Friday

Here is how the data should be pulled and allowing me to edit the data through a form:

id tailnum sched dadate configF config acid strdate
254046 3816 SP 24-Oct-05 C23FM 201 Monday
254047 3816 WA 25-Oct-05 C20F 201 Tuesday
254048 3816 SP 26-Oct-05 C20FM 201 Wednesday
254049 3816 FLY 27-Oct-05 C20FM 201 Thursday
254050 3816 FLY 28-Oct-05 C20FM 201 Friday
254051 3816 29-Oct-05 201 Saturday
254052 3816 30-Oct-05 201 Sunday

[code]
ALTER PROCEDURE test
(@v_acid int = '201')
AS SELECT DISTINCT
s.id,
a.tailnum,
s.sched,
s.dadate,
s.config,
f.config AS configF,
f.acid,
DATENAME(dw, s.dadate) AS strdate
FROM dbo.sched s
JOIN dbo.aircraft a ON s.acid = a.id
LEFT JOIN dbo.flysheet f ON s.acid = f.acid AND CONVERT(VARCHAR, f.dadate, 101) = CONVERT(VARCHAR, s.dadate, 101)
--JOIN dbo.flysheet f ON s.acid = f.acid AND DATEDIFF(d, f.dadate, s.dadate) = 0
WHERE (f.acid = @v_acid)
ORDER BY s.dadate
[code]
I believe this should bring back all your records...

As for the editing you really need to give us more information about what you are actually doing for your editing....

No it didn't work. It's only pulling information that ConfigF has, not everyday of the week or config. I know the problem is with configF since it is really config and just creating a new column name (configF) from it. I've tried every join there is and I still can't get it to pull everyday of the week and edit the configF data. The only way I can do this is through the table but my controllers need to edit it through the form in access.