Sub Report table which has Date only

[raffi]

hello, i have been using access for 3 weeks now and finally i feel like im getting somewhere but unfortunately im having a slight problem



as i have learned inserting sub reports into reports by merging Primary keys into the main table or junction table are very beneficial and the more tables there are the more ull be able to create sub reports and create filters right ?

so what i did was i created a table only setting a Date Field and the primary key with its autonumber, and set that date fields default value =date() so it always shows present day, and then linked it to the main junction table so i can never type the wrong date, and also for later on i can search by date, not only by customer name, but its not working, in the conjunction table its giving me blank, is it because it is set default value =date() ? or dates cant have foreign keys ?

[pbaldy]

I don't quite understand the purpose of the table, but the default value only determines what the value will be if you create a record. If you never create a record, there won't be a value there. From the sound of it, I'd use the default value of the date field in your main table, or the default value property of a textbox on your data entry form.

[raffi]

im apologies for the misleading term a bit i explained wrong but i think i figured out what i needed if lets say the given situation is, i have a table, primary key Field name called DepartureDateID and its Data type Autonumber and under it field name again departureDate and next to it the datatype would be date/time and the default value of that field will be =date() , is there a way to generate autonumber automatically each day in the table ? if so it will also create a new date since there is =date() the default value, and i think it will be perfect.

im doing this so, when ppl type in a date number in form, and click on the report, they would see what was that particular days all daily movements,

[pbaldy]

Ah; I've never seen the point of a table like that. I just store dates (and it seems more intuitive for the user to type in a date). In any case, if you want to go that way, I'm not sure I'd bother trying to create a record every day. It would be fairly easy to run a bit of code that created the next x days in that table. You could create 5 days or 50000 in an instant.