Search results

Hello Bob! On the Report in Details I have Text-Box "Price" ,Text-Box QT3 and LossMoney Where I put my expression, it does the calculation. then On the Footer of the report i created one unbound text box "TotalSum" and needed to sum the results which gave "LossMoney"

Hi Bobo, Thanks for the answer... I tried it but not worked, does nothing

Hello Friends, Need your help! Something wrong, Can't Sum On the Report Footer In the detail I have Unbound Text-box "LossMoney" With Expression =Nz([Price])*Nz([Qt3]) working ok giving the correct results. Now at the footer of the report I want to sum the "LossMoney" Tried many variants, but...

I'll Try Everything!

I'll try to make Sub-report and then merge, but how to count the totals with merged report?

Hello Dear friends, I have a question if it is possible and is the right way to join 2 Queries, 1 Distinct and the Second non Distinct Both of them is working properly independently

Hello Speaker_86 I downloaded Aphrodite V2.0 But is not working. I already have Enabled all Macros Security

Greatest Thanks vbaInet Works Perfectly Does What I needed! Super!

I set QRY1 for the Record Source for the form (QRY1 is not with distinct) when form being opened it must display everything without distinct, when clicked DistRec it must distinct the records

Hello VBAINET, Thanks for the quick response, it says that: Select Statement includes a reserved word.... I'll use another name for example QRY1 and QRY2

Opps! Sorry AmyAimee

I think He meant to highlight the selected record on the continuous form

Button Caption For Example Will be "DistRec" Being Clicked It will distinct the records (Will change to another query which is distinct)

For Example I Can do: Me.RecordSource = "QueryName" Is it a good way?

Thanks a lot You explained Everything with it!

Hello I have a question About DISTINCT The Records by a command button. I searched but, can't find anything like that.. I have a Continuous form based on a query and I use "SELECT DISTINCT ........ it works perfectly DISTINCTS the records as needed, but i want to add on the form a command...

Hello vbaInet The field "Barcode" Is Non-Distinct... My one Report is based on that Query, on the report I use the Text Box "Barcode" How to solve this, Other fields are to be DISTINCT Except one field Barcode

Hello Mates Need your Help! I have report which is based On a QRY "QRYName" I use distinct, for example: SELECT DISTINCT QUERYDATA.Product, QUERYDATA.Brand, QUERYDATA.Model, FROM QUERYDATA I want to add a bar code but how to exclude it from distinct? Thank you in Advanced

Thanks for the reply, I know that: but want to know how to accomplish the command from Access by a command Button.... Being Clicked: It must copy predefined font(s) from that place and then copy to the Windows Fonts directory I have my variant: I'm opening from access a Batch file and the...

I did it Works Perfectly vbaInet I'm SysAdmin My main field is Networking and building Enterprise Company Networks... I also creating small databases in Access (Greatest Thanks You All for helping me in Development)