Search results

You can use smart tags property of field

Yes you can

Use the unmatched query wizard

Here is a good example of this

if you see the result he required he want two row for type w for each date where shift is same but there are more than one codes In simple crosstab it cannot be achieved directly

Games and Tricks In Access Attached file contains some games and tricks developed in access.

This can also be achieved by using just one form with a list box check the attached sample

I have made 2 changes In your query i used Like "*" & [Forms]![Form1]![mycriteria].[text] & "*" instead of Like "*" & [Forms]![Form1]![mycriteria] & "*" and second removed me.refresh from code when you use onchange event you have to use text property of control

Uploaded again

It is same file you uploaded open it with access directly

Download the ammended file

Actually you cannot use groupby for value field in crosstab so the solution is a little tricky Download the attached file and check the query FinalCrosstab It is based on another query query1

you should not be maintaining seperate tables for each year you can use one table for all years and then data can be filtered for each year whenever required

Use the solution given to you by Neileg Paste the sql in the sql view of query

Write this code in the onformat event of section (in which your control resides) if isnull([abc]) or [abc]=0 then [xyz].visible = false else [xyz].visible = true end if

two queries are suggested to you query1 will be the name of first query whatever name you give it replace query1 with that name

There is no attachment

Sorry i didnt read it properly Neileg's solution is perfect

Try this Me.Combo2.RowSource = "SELECT [hips_product].Product, [hips_product].Quantity, [hips_product].Sales_12_month, [hips_product].Sales_3_month FROM [hips_product] " & _ "WHERE [HOSPITAL NO & NAME] = '" & Me.Combo0 & "' ORDER BY [hips_product].products" Me.Combo2.Requery

Use This sql Select C1,C2 from Yourtablename where c1=2