Hi all,
this is the situation:
Tables: Customers, Bills (fields BillID, CustomerID, DateFrom, DateTo, BillingDate, Paydate), Hourlog (fields LineID, CustomerID, Text, Date, Hours, Rate)
Forms: Customers with Hourlog subform, used to record hours worked for the customer (works fine)
When I want to make the bill, I will choose the customer and specify the period to select from (Using Fields DateFrom and DateTo). This can be specifed in a form. Now I am encountering trouble, How can I use the specified form or tabel values in a query? I MS Access I would have used the expression builder to get the numbers from the table or form, but in OO I can't find any tool similar to the expression builder. When I am setting up a query to get the data, I have tried using BETWEEN in the criteria, but it doesn't allow me to use fields in the function.
Can anyone give me a hand in this, please?
Marius