|
Administrator: Receipts
"I'm late! I'm
late!
For a very important date!
No time to say
hello, goodbye!
I'm late! I'm late!
I'm late!"
Is the video overdue? Now, your query has to determine
if the DaysRented is greater than the rental agreement.
Look at the
description field in
tblRental. The data says,
“3-day rental.” Is there a way to remove the text and just leave the
first number? Sure.
Try it: Use the Left Function
Open rptCustomerReceiptSQ in Design View.
Insert a new column into your query.
Type
the Left code:
Rental: Left([Description],1)
Where Rental is the Label
Left() is the function
1 is the first character in the data
[Description] is the field in tblRental
Test your results and Save the query.
|
|||
|
| |||
