Search results

There may be a better way, but I'd do it using 2 queries. The first is a totals query , group by Account NumberField and do Count on TransactionField. Enter criteria of >1 under TransactionField Then create a second query which joins query 1 to your table on Account NumberField and run it...

Add the field that contains the Sa etc into the query grid twice, choose Group By under one of them and Count under the other, that will give the desired output.

Set the control source of the text box on your report to =Forms!NameofForm!Nameoftxtbox, substituting your actual form name and name of text box that holds the date. The form will have to remain open when the report runs.

Hi, You as you say need 2 forms, which are both based off the same query. Have a look at the attached and look at the forms named Companies and Prods. Companies lists all products bought by certain company and Prods lists each product and the company that bought it. Have a go using the form...

Take a look at the attached query and form. Is this what you are after for your form? It allows you to add new records to either table and also links existing records and uses a subform. Create the query and then use the Form wizard, it will create the form for you.

Create a query and join the two tables in the query, and then use the query as the source for your form.

As an English person who visited Quebec last year I agree with what Newman has said about snobbery in Quebec. I did have some concerns before I visited as i had heard the people were as snobbish who would only converse in French even though they could speak English. However I had no problems...

You can import your spreadsheets into the tables by clicking File, selecting Get External Data then selecting Import and following the wizard. If you dont have details to populate the employment table in e.g. a spreadsheet you can upload then you will have to manually complete the table, as...

You're welcome! You'll learn a lot from these forums as you go along, I promise you. Glad to help :)

You need an update query. Add your two tables to the query grid and create a join on the field names that may contain matches. Click on Query Type on the toolbar and select Update Query. Add the field you want to update and in the Update To Box enter "*" This is the SQL UPDATE Table1 INNER...

Yep :) , use something like RECCOUNT:1

If you really must add a column to your query like the following, it will append 1 as a field to each record COUNT:1

If you are certain you want to do it, using iifs and setting your table out like a spreadsheet and not using subtables, see query1 in the attached.

You would need only one sub table, take a look at the attached example and in the query qrypriceeg you will see how different prices are charged for the same product depending on the customer.

To be honest now I've read your descriptions the iifs arent the way to go I don't think, it is joins, also the way yopu have set up the product table up doesn't sound right. What you need is another table called e.g. productprice, in it you will have fields productid pricecode price I don't...

Ah ok so i was right first time :) So it is the iif, add an extra column to your query by typing or pasting the following into your query grid UnitPrice:IIf(Customers.PriceLevel=1,1,IIf(Customers.PriceLevel=2,2,3))

Sorry, Scratch what i posted earlier, I answered something different to what you asked I think. What you are needing to do is pick up the correct unit price from your products depending on customer? Add your two tables to a query and create a join between the two on price level. To do this...

If the field is always the same length then use Right([nameofyourfield],6)

Yes youre on the right line, you need an update query, put your Product field in the query and in the update to part put Replace([Product],"_"," ") HTH

Create the join in the query, it worked fine for me and returned 1 record. At the moment its returning all possible teachers for each house because the link between the student and pc group in ther query isn't there.