Ok, I have a main form that has four unbound combo boxes on it. The first is for date with a pop up calendar, the last three are other controls with dropdown items. This is linked to a query where I do the query by form. Also on the form I have a subform that shows the results of the query by...
Dhookom you seem to answer all my questions, and here I am, yet again, with another question. You answered my question about creating an outer join to show all dates, which is the perfect solution, but now I've been searching posts trying to find out how to create a table that will...
I am trying to create a report bi-weekly to show days worked, but the problem I'm having is that if I have no entry for the two days, it doesn't show the days on the report. I need the off days to be listed also, but just can't figure out how to get there. Thanks in advance.
Ok, another simple question that seems to keep eluding me, I've searched all the FAQ's and looked in the forums, but still puzzled. I have a table where the primary key is the date, only one date per record, no duplicates. I want the table to automatically go to the following date. Example...
I'm working on a database that has, among other things, a time sheet. I'm trying to make my database and comply with all the normal form rules. So far, my table has DateWorked, RegularHours, OvertimeHours, CompTimeHours, CompTimeUsed, SickTimeUsed, and VacationTimeUsed. At this point, since...
I have a Table with a Date field. The next field is "Day of Week". I'm sure this is a basic question, but I have been beating my head against the wall. How do I get the "Day of Week" field to automatically populate when I enter the "Date" in it's field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.