G
Guest
hey all, i can't figure this one out... help!!
I have a form used for printing timesheets, of which i'm usnig a table to
store the hours worked. i have a "table" of text boxes i use to display the
date , time in, time out, and total hours, with 16 rows to display either the
first or second half of the month (1-15th or 16th-31st). the date is kept in
the table along with the sign in and out times. what i want is for the time
in and out fields on the form to lookup the date for that row and display the
time if found. i have created a query that will give me what i need, except
i can't figure out how to specify it to pull the time for the date given.
alternatively, i was going to use a manual SELECT query but cannot figure out
the proper syntax (it keeps giving me errors)
anyone who can help, it is much appreciated... if you need clarification plz
post
I have a form used for printing timesheets, of which i'm usnig a table to
store the hours worked. i have a "table" of text boxes i use to display the
date , time in, time out, and total hours, with 16 rows to display either the
first or second half of the month (1-15th or 16th-31st). the date is kept in
the table along with the sign in and out times. what i want is for the time
in and out fields on the form to lookup the date for that row and display the
time if found. i have created a query that will give me what i need, except
i can't figure out how to specify it to pull the time for the date given.
alternatively, i was going to use a manual SELECT query but cannot figure out
the proper syntax (it keeps giving me errors)
anyone who can help, it is much appreciated... if you need clarification plz
post