to Mr. Allen Brown

L

louis

thank you for your help,

in fact, i hv already got a table containing all dates,
i just do step3-7.

However, after i've run the append query, "no rows is appended"~~
my append query is :

Field: TheDate
Table: tblDate
Append to :myDate <-------this is the field in a table i store the target date range
Criteria: Between [StartDate] And [EndDate]

i got 3 tables, 1 stores all the dates, 1 stores the startdate and enddate, the last one stores the target date range,

thanks ~~~
 
A

Allen Browne

I think StartDate and EndDate cause Access to pop up 2 dialog boxes when you
run the query? If so, declare the parameters to ensure Access understands
the data type:
1. In query design view, choose Parameters in the Query menu. Access opens a
dialog.

2. Enter two rows in the dialog:
StartDate Date/Time
EndDate Date/TIme

If that does not solve the problem, switch the query to SQL View (View
menu), and post the SQL statement.

BTW, if you can find your original thread and post a follow-up, it helps us
to follow the threads of the issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

louis said:
thank you for your help,

in fact, i hv already got a table containing all dates,
i just do step3-7.

However, after i've run the append query, "no rows is appended"~~
my append query is :

Field: TheDate
Table: tblDate
Append to :myDate <-------this is the field in a table i store the target date range
Criteria: Between [StartDate] And [EndDate]

i got 3 tables, 1 stores all the dates, 1 stores the startdate and
Click to expand...
enddate, the last one stores the target date range,
 
Top