Search results

Using IIf to get a result Hello, I would like to convert a numeric value into something more meaningful for my users. I thought about using the IIf statement, but cant get it to work. What I basically want is: If question 1 = 5, then the answer is "good", If question 1 = 6, then the answer...

Example Hello, Thank you for your reply. Here is a simple example made in excel. It shows the names and a total. So how would I get a query to calculate the 6? Thank you. dj_T

Hello, I have a report that calculates the total at the end of the report. What I would like to do is: take this calculated total and divide it by a number. The problem is that this number is a staff total and comes from another unrelated query (a different query source than that of the...

only 1 Hello, Well, what happens when I do that is this: The query counts the column to the left. So, it correctly displays a "1" in the counting column. There is only one name - so it counts it as "1". What I need to do is calculate the number of entries returned in a particular column of a...

Hello, I have a very simple query: one column contains names the second column contains a count of the name so, the query looks somethin like this: Name CountOfName A name 1 B name 1 C name 1 etc.... What I would like to do is somehow total all the...

Weekends Well actually, I may need to do weekends. Is that possble completely within a query? Or would I have to use VBA? dj_T

great Thanks! It works just fine. dj_T

Hello, I have a query which has a start date and an end date. I would like to count the number of days inbetween the two dates so I used the following: TotalDays: ([EndDate])-([StartDAte]) This works BUT! if the start and end date are the same, then a value of 0 is returned. What I need is a...

Got it! Ah... I re-checked my typing and re-read your post. And finally it worked! I have created multiple columns and it works great. Thank you very much! dj_T

thanks and help! Hello, actually, there is no underlying table for the form - its just a collection of comboboxes. The user selects something (like name or company - which themselves come from a query). This is then passed to a control. This control is then available to the the query. I...

Hello, I am trying to make a "report" style screen that will allow users to call up a report based on the criteria they enter. The query is passed the parameters from the controls on the form. This works fine. Now in order to allow for user selection, it was suggested to use the following...

Great! Thats really super - it works like a treat! One other minor question - how might I allow all the records to appear if the user selects an entry such as "All Records"? Thank you very much! dj_T

All Ah yes - I see. I have been able to reference a control from my query (using [Forms]![fromName]![ControlName]) and this works fine. But, if the user doesnt select any item from the menu (or an item such as ALL) how can I show all the records? I tried leaving the control blank - but the...

Hello all, I have a question concerning the preview of reports - based on a user selection. So far, this is what I have done. I created a blank form. On that form I created a drop-down combo box. This combo references a table that contains the exact names of the reports I have already...

Great! Ah thats great! Works fine now. Thank you for your help. dj_T

Hello, I have an usual problem with a list box. A listbox is placed on a form, which references a table with staff details. The list box is setup to select a record based on the choice the user makes. So far, no problem. The user can select a name from the list and it will select the...

Hello, I would like to generate a report in a calendar style. That is, I would like the data to flow from left to right, then wrap round to the next line. Currently, by creating headers (or sections) the report will only generate vertically. How can I produce a report horizontally? Thank you...

I see! Ah yes! Found the on change! Thanks for your help. dj_t

how about this solution? Hello, I did a search on "requery" and I came up with a soloution. What I did was attach the following code to a save button on another subform, on another tab: Forms!frmMyForm!subFrmMySubForm.Requery It appears to work - when I click the save button it...

Placement of code Hello, Thank you for the reply. But, where do I place this code? For example, the tab itself only has the following: On click Dbl click MouseDown MouseMove MouseUp These events only occcur when the user performs an action on the actual subform. Where would I place the code...