Recent content by Dimitris

You r right. The answer can be found HERE

already found the answer on another thread. Tks. Should had cheacked more before.

Dear all hi, in a Form i have 2 SubForm which i need to link. I have one SubForm in the left showing the contracts list (Continous Form) and on the right I have another SubForm with the contract details . What i need is to click on a record on the left SubForm and then get the details on the...

i have only 2 type of vehicles but their values are not only 2 and 3. sorry if i coused confusion by the way i explained but i just gave these figures as an example. the IIF cmnd will return only values 2 or or 0 (isn't ???). Filter also is not the needed solution since i need to see both...

Sorry for late reply. I'll try with dsum. tks for helping D.

many tks Rainman but this is returning back the number of records.that would work great if i had 1 vehicle per each record. But i have the following: example:for 1 record with type A (type of vehicle) =3 vehicles another record with Type B=2 vehicles if i got it right , Dcount will...

Hi everybody, i have a (Continuous) form that gives me some loading details like: Date, Type of Vehicle, Number of Vehicles, Destination, Weight....etc etc. I have 2 Types of Vehicle. TYPE A and TYPE B. In the Form footer i get the sums i need and also the sum of Vehicles but for both Types...

Tks a lot namliam. it was so easy that makes me feel like stupid :) cheers/Dimitri

Hi all and merry X-mas (to come) I wish to get a report from a query that gives me data shorted by date. In the report i can Group by date BUT what i whant is to group BY MONTH. for this i need to transform the date field into another that will show me Only the Month + Year (without date)...

it works perfect into the example. Thanks a lot ByteMyzer. Now i have to make it work into a complex query that i have. If dont make it i know who to ask :) Tks again

tx for the reply. will try it.

Dear all hi, Firt time posting here and new with access. i have the foll to ask: have a table from which i need to take in a query 2 fields into 2 seperated rows example: my table has fields..seller-supplier1-Quantity1-Supplier2-Quantity2. in every query i've tried i get one row with both...