Search results

The IIf function should work Try this IIF([SalesItemID]="EP006",sum([No],??) The ?? is the value that you want to return if SalesItemID is not equal to "EP006"

Datum: DateSerial([SELECT Year FROM QueryTotal];[SELECT Month FROM QueryTotal];1) create a new column in your query yourYear: format(yourdatefield,"YYYY") create a new column in your query yourMonth: format(yourdatefield,"MM") reference these new fields in your code

The attached database does what you want and more it was posted in this forum a while ago (can't remember who designed it..apologies ) Open the database and design form frmsearch right click on the search button properties on click and check out the code. Also checkout the Private Function...

The attached database does what you want and more it was posted in this forum a while ago (can't remember who designed it..apologies ) Open the database and design form frmsearch right click on the search button properties on click and check out the code. Also checkout the Private Function...

What seems to be the problem ?

You could create a table that contains all your genres Create a combox on your input form based on the new table That wy the user select a genre from the combo box eliminating user typeing errors

SELECT tblUTD.[Event Id] FROM tblUTD WHERE (((tblUTD.[Start Occurrence]) Between [Forms]![filter_form]![Txt_OccurenceDate_Start] And [Forms]![filter_form]![Txt_OccurenceDate_end])); Have you tried creating a query with the above selections to produce results then looking at the sql it produces

RE:Exemptions list You can use the currentuser function; dim username as string username = currentuser Then use the Username variable to work out your exceptions

Put the code in the field section of the query not the criteria section NewRate: [elapsed]*1.5

I would try refreshing the links to the tables

RE:report created - need help with parameters!! You could create a form with a text box for each parameter In your query in the relevant column (wher the parameters need to be) type forms![newformname]![field1name] repeat for each parameter in each query on the form create a button to run the...

On enter of 1st listbox me.listbox1.requery me.listbox2 = 0 me.listbox3 = 0 on enter of 2nd listbox me.listbox2.requery me.listbox3 = 0 on enter of 3rd listbox me.listbox3.requery

Sounds like you don't have update permissions to the database, you may need to contact the database admin guy to give you access

In the on click event of the button you can validate your fields eg if nz([fieldname],"") ="" then msgbox "Please supply a value",vbinformation,"Invalid entry" fieldname.setfocus exit sub end if Just repeat for each field (the above checks to see if the field has a value)

In the query that the roport is based on select an empty column and type this in the criteria section NewRate: [yourtime differencefield] * 1.5 (1.5 being the hourly rate for example) then your report create a text box and type Newrate in it's control source

In the query that the report is based on ad a new column shortened: Trim(Right([fieldname],4)) then in the report base the field you wnt to print (with shortened number ) on the field shortened

REFilling in a text field with data from another In the on load event of your form; if nz([datebooked],"") = "" then [datebooked] = [daterequested] else msgbox "This date has already been booked",vbinformation,"Already Booked" end if

Create a query that selects the data you require from your table. in the same query add the following column; Stamp: IIf([amount]<=1000,1,IIf([amount] Between 1001 And 2000,2,IIf([amount] Between 2001 And 3000,3,IIf([amount] Between 3001 And 4000,4)))) Just keep going until you reach the end...

e.g. SELECT tblANIMAL.animal_id, tblANIMAL.owner_ID FROM tblANIMAL WHERE ((tblANIMAL.owner_ID)=(THE OWNER_ID FROM A TEXT BOX IN A FORM)); SELECT tblANIMAL.animal_id, tblANIMAL.owner_ID FROM tblANIMAL WHERE ((tblANIMAL.owner_ID)=(forms![yourform]![yourtextbox]));

I personally would have the form based on the table or preferably a query create a button using the wizard and select record operations then undo record. this will undo any entries in the form create a button again using the wizard select record operations then save record