Create a table

J

jeanulrich00

Hi

I have a form "FrmMenu" and 2 text field on this form "StartDate" and
"EndDate" format is dd/mm/yyyy

I want to create a table using those 2 fields

If the user pur 01/01/2008 in the "StartDate" text field and
31/01/2008 in the "EndDate" text field

I want to create a table "PeriodTemp" with one field "DatePeriod"

and when I open the table it shows

01/01/2008
01/01/2008
03/01/2008
and so on until the "EndDate" 31/01/2008

What should I do ? Use a Make table query that would have criterias
based on the 2 fields of the "FrmMenu" form ?

Thanks for helping
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top