How to write a query to display only jobs of current date

[Vidya]

I have a Table for Job and a Table for Transactions, I enter daily
Transactions and debit employee time to the Jobs which are on hand. I
want to display only Jobs on Hand by comparing the current date to
completed jobs date in the Combo box to select.
Can any one help me

 

[davea]

Without knowing your database structure I would suggest using a query
to pull out current jobs in hand and setting the record source of your
list to that query.

Can you tell me if the jobs in your system have a start and end date
associated with them and if jobs in hand refers to those jobs with no
end date? If this is the case then its simple to extract all current
jobs using a query and display them on a form list.

 

[Vidya]

Yes I have a table for start date and End date, I enter the Start date
and once the job is completed I enter the End date for the job.
I enter daily transactions for activity of each employee in the
Tranaction like, Date, Name, Start Time, End Time and select the Job
Name.
Once I start Enter daily transactions, only job completed date which
are null should be displayed in the Combo box to select.