Search results

in your query try this where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing Saleprice:iif([onSalePrice]= -1,[price]*0.9,0) (if onsalprice is ticked multiply price by 0.9 else make it 0)

Create a report based on your query then in the onclick event of your ok button replace the code that calls the query calling the report instead

I would create a form with a combo box that selects all the customers names create a query that selects all the info you require and in the customer column of the query type in the criteria section forms![yourformname]![yourcomboboxname] create a report based on your query add a button next...

If you right click on your shortcut select properties then select the shortcut tab in the run section select maximize

try a query like this select agent, SELECT yourTable.agent, Sum(yourTable.Commissionamount) AS SumOfcommissionamount, FROM Table2 GROUP BY yourtable.agent;

try between[Forms]![DTdates]![StartDate] And [Forms]![DTdates]![EndDate]]

RE:Play mp3 I have had a look at the attached db but cant seem to get it to work When the form frmWindowMediaPlayer is about open it fails with object does not support this propert or method On the form load it doesn,t like the following code Me.WindowsMediaPlayer0.URL = AudioPath I have...

Basicly Im not sure how to parse out the date to only look at the mm/dd Format([yourdatefield],"MM/DD")

design your Cross tab query and on the menu bar select query and then parameters Enter your parameter >=[Forms]![DTdates]![StartDate] And <=[Forms]![DTdates]![EndDate]

Table1 Code , amount a 10 b 5 c 2 b 10 a 20 c 10 SELECT table1.code, Sum(table1.amount) AS SumOfamount FROM table1 GROUP BY table1.code; Result Code , amount a 30 b 15 c 12

In your add both tables create a join between table1.testcode and table2.testcode right click on the join and select option 2 (include all records from table1 and only those records from table2 where the join fields are equal) Select the colums you want from table1 and also the testcode column...

IIf(IsEmpty([QF_VISUAL_INSPECTION_sumdefect!SumOfdefect_no]);0;[QF_VISUAL_INSPECTION_sumdefect!SumOfdefect_no]) Try This IIf(Isnull([QF_VISUAL_INSPECTION_sumdefect!SumOfdefect_no]),0,[QF_VISUAL_INSPECTION_sumdefect!SumOfdefect_no])

In the on open event of the form use the following code DoCmd.MoveSize(,,800,600) (when I tried it the form was very small just increase the numbers until you reach the required size)

Can you post a copy of your database so that we can take a look

I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen design your form on the form properties choose the format tab then change the auto center...

Second I haven’t figured out how to call up the customers information from just the account field. In the after update event of the account no field dim CustomerInfo as string customerInfo = nz(dlookup("[nameofcustomernamefield]","[queryname]"),"") [formcustomerfieldname] = customerInfo...

If you are using SQL use the case statement select ask as , 'ask'= case when ask = 'B' then 'A' else 'ask' end from ain_test1 if you are usin an access query in the field name of ask column replace ask with askorig: iif([ask]="B","A",[ASK]) I hope the syntax is correct but I...

Place the following in your code Dim ans As Long ans = Int((99999 - 11111 + 1) * Rnd + 11111) will produce a random number of 5 digits 99999 the highest no in the range 11111 the lowest number in the range

oops I have attached it this time The Form will need tidying up

Have a look at the sample databases in this forum they may be of some use to you