Search results

In answer to your first question add a join on PC Group between Student and PCT Table Secondly set control source of Text 20 to =Count([surname]), that will count the number of students

Just thinking out loud here, but you could add a calculated field to your query like the following e.g. Period: DatePart("m",[yourdatefield]) Group by that and count on your work units.

So are you wanting to identify which country ids have artists and which don't? Create a query using a left outer join between country and video tables on country id and use country id as a field from both tables in your query and group by it. When you run the query where there are matches the...

Great , glad to help

You need to change your joins between the tables, currently they are inner joins which only pick up records if they exist in both tables, you need to use a left outer join between the member and transactions tables, this will select all member records and transaction records if they exist. To...

Hi, If I'm reading you right you want a query to select records that fall either a certain number of days before the due date, on the due date or 7 days after the due date. You can use the following criteria under your due date field Date() or Date()-7 or Date()+7 This will pick those...

Ok, I've fixed it for you, I reinstated the opensearchrole macro behind the Display button (sorry I should have said that in last post) See attached db .

Ok, you need to create a new macro, call it opensearchroleform and put that in the on click event of the Search By Role Run command button on the menu. The opensearchroleform macro should open the SearchRole form.

The onclick you have is set to opensearchrole, if you look at that macro it is set to open the searchrole form, you need to change it to Open Query SearchRole.

Hi, Ok I've had a look, looks ok, you just need to finish it off by: 1. Adding an On Click Event to your Display button to open the query SearchRole 2. Put this as your criteria in the SearchRole Query under the Role column [Forms]![SearchRole]![Combo0] That should sort it for you.

Because on the others you are asking for a value and not limiting what the user can enter as criteria, whilst in this query you are limiting the criteria a user can enter by providing a list of what they can search on, unless I'm reading what you asked for wrong. If you just want a prompt for...

You need to create another form with a combobox on it, that allows the user to select one of the specified roles. Change the OnClick of your menu Search By Rule button to open up the new form and add a button to your new form that runs the query. In your query you need to add the following as...

Hi, you need to use Iif and DateDiff, add a calculated field as below e.g. CurrentPrice:Iif((DateDiff("d",Purchasedate,Date())>365 And <731,[Value of Purchase]*0.8),Iif(DateDiff("d",Purchasedate,Date())>730 And <1096,[Value of Purchase]*0.6),[Value of Purchase]) This does it for the first two...

One way i can think of is to use a subreport for the 7+. Create a query for the 0 -6 and then another query for the summary 7+, base the main report on the first query and then add the subreport to the report.

Set the control source of the text box to: =DateDiff("n",[Begin],[End]) this will give the difference in minutes between the two times.

Hi Thats where your problem stems from its grouping by every single date and time. Remove your date field from the query and create a new field like the following: NewDate:Format([nameofyourdatefield],"dd/mm/yyyy") replacing nameofyourdatefield with the actual name of your field and the...

Put your date and sales columns in the query, and make it a totals query by clicking the sigma icon , under your date column select group by and under your sales column select sum. Thus will give you the total sales per day.

Hi, this works for me, you could adapt it to fit to your form name Dim stDocName As String Dim stLinkCriteria As String stDocName = "Table2" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.GoToRecord , , acNewRec It opens at new record but lets you scroll to previous records.

It so often is, glad its sorted

What comes through from the form will be a single record.(the record that is visible on the form) Can you not replicate the calculation in your report instead of doing it in the form and bringing it in, if you want to display multiple records in your report?