Newbie SQL help needed

[maverickmonster]

I have made this SQL query and need help finishing it off, I want to make the table report_details with all the data from detail table where the table today field today is the same as table details from target completion date.

INSERT INTO report_details
SELECT *
FROM details
WHERE [today]=[details]![target completion date];

Thanks in advance

Maverickmonster

 

[mordja]

INSERT INTO report_details
SELECT *
FROM details
WHERE (((details.[target completion date]=[today]));

Mordja

ps what is [today] supposed to represent field or input ?

 

[PHV]

Perhaps something like this ?
INSERT INTO report_details
SELECT *
FROM details
WHERE [target completion date]=Date();

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244