How to Report through Form

[ishchopra]

Hello Experts,



I am zero level in Access and trying to create a simple form based on Query.

I have one query which have three columns

Offer_ID
Week_Won
Week_Num

Now this query shows consolidated result, what i am looking is to design a form which inputs Week_Num from user and only return respective week values.


For instance : form should have two fields and one button

Week_Num From: _____
Week_Num To: _____

BUTTON -


first user will enter the from week_num and then To week_num after clicking the button it should show the records belong to user inputs.

Can somebody help me to write a VBA code for the button ?

any help is appreciated

Cheers !

[ETCallHome]

Hi,

You will need to give a little bit more than this... post the actual field names you are using and the table/query name, and I will try and create some code for you to use to accomplish you results.

[ishchopra]

Thankyou so much for replying:
SELECT A.offer_id, A.week_won,A.Week_num
FROM TBL_Raw_Wins_Week28 AS A LEFT JOIN TBL_Raw_Wins_Week29 AS B ON A.offer_ID=B.offer_ID
WHERE B.offer_ID Is Null and A.offer_Id <> "";

union all

SELECT A.offer_id, A.week_won,A.Week_num
FROM TBL_Raw_Wins_Week29 AS A LEFT JOIN TBL_Raw_Wins_Week30 AS B ON A.offer_ID=B.offer_ID
WHERE B.offer_ID Is Null and A.offer_Id <> "";

union all

SELECT A.offer_id, A.week_won,A.Week_num
FROM TBL_Raw_Wins_Week30 AS A LEFT JOIN TBL_Raw_Wins_Week31 AS B ON A.offer_ID=B.offer_ID
WHERE B.offer_ID Is Null and A.offer_Id <> "";

union all

SELECT A.offer_id, A.week_won,A.Week_num
FROM TBL_Raw_Wins_Week31 AS A LEFT JOIN TBL_Raw_Wins_Week32 AS B ON A.offer_ID=B.offer_ID
WHERE B.offer_ID Is Null and A.offer_Id <> "";

UNION ALL

SELECT A.offer_id, A.week_won,A.Week_num
FROM TBL_Raw_Wins_Week32 AS A LEFT JOIN TBL_Raw_Wins_Week33 AS B ON A.offer_ID=B.offer_ID
WHERE B.offer_ID Is Null and A.offer_Id <> "";
================================================== ==================

Table Names :

TBL_Raw_Wins_Week28
TBL_Raw_Wins_Week29
TBL_Raw_Wins_Week30
TBL_Raw_Wins_Week31
TBL_Raw_Wins_Week32
TBL_Raw_Wins_Week33


Please let me know if you need more information..