movaheditabrt
New member
- Local time
- Today, 06:31
- Joined
- Oct 6, 2011
- Messages
- 7
Hi there!
I'm really new to access. I'm using access 2007. I've studied about table,query and form and know nothing about macro and vb. thus, please help me regarding my knowledge of access.I have three tables: agentstbl : [agent-ID] , [name] , [sale-id] , [distance] , [town] , [impassable] , etc
pricetbl : [from date] , [to date] , [saleID] , [city] , [difficult-pass] , [from distance] , [to distance] , [price]
billtbl : [billno] , [date-f] , [agent-ID] , [name] , [t-price] , etc.
values of [town] , [impassable] , [city] , [difficult-pass] are 0 and 1 and 2.
in order to [t-price] be filled automatically in a form , these criteria must take place in query :
[sale-id]=[saleID] , [town]=[city] , [impassable]=[difficult-pass] , [date-f] between [from date] and [to date] , [distance] between [from distance] and [to distance].
how can I do so? which function and what is it like(the expression)?
thank you
I'm really new to access. I'm using access 2007. I've studied about table,query and form and know nothing about macro and vb. thus, please help me regarding my knowledge of access.I have three tables: agentstbl : [agent-ID] , [name] , [sale-id] , [distance] , [town] , [impassable] , etc
pricetbl : [from date] , [to date] , [saleID] , [city] , [difficult-pass] , [from distance] , [to distance] , [price]
billtbl : [billno] , [date-f] , [agent-ID] , [name] , [t-price] , etc.
values of [town] , [impassable] , [city] , [difficult-pass] are 0 and 1 and 2.
in order to [t-price] be filled automatically in a form , these criteria must take place in query :
[sale-id]=[saleID] , [town]=[city] , [impassable]=[difficult-pass] , [date-f] between [from date] and [to date] , [distance] between [from distance] and [to distance].
how can I do so? which function and what is it like(the expression)?
thank you
Last edited: