Search results

I have a problem (hopefully simple) with a query which is supposed to show its results in a subform. The query searches a member table to display all names based on a wildcard search using a textbox as its parameter source(searches the surname).The query itself works BUT I want to display this...

Thanks for the suggestion - I have tried that but still can't get it to work - not really sure what I'm doing wrong? :confused:

Hi I have already posted this message in Forms but maybe it really is a query issue. My database works out monthly archery scores for a small postal league- each team has 5 or 2 archers (depends on team) and I want to have a record of each archers totals for awarding results total up the...

Hi Mark What is your relationship between the tables?I assume that the same data goes into one table from the 4 forms- what about a form based on the table with the data above and then use subforms. It does depend on how your database links together. If you create a form based on the table...

re calculated totals Yes- I did try using the "Totals" option in the query but it just gave me the total of each individual archer so not sure what I was doing wrong- I have attached more details to explain what I'm doing.Hopefully someone can make some suggestions.

I need some advice about how to copy/enter/export some calculated fields from a form into a table(with the same field names). I have a form based on a query which finds all the archers who have shot a score based on a Division parameter, this may be 2 or 5 archers, depending on the division.The...