Export button (1 Viewer)

[crislim1113]

Hi..Can someone help me with this?
I want to export the filtered data on qryRequirements based on the selected month on this. How can I do it. I know how to export a query table to excel, but I dont know how to filter it.

Regards,
Cris

 

[namliam]

What else would you need but to TransferSpreadsheet?

In your qryRequirements you can easily "where QueryMonth = Yourform!SelectedMonth" and all you need is to export it?

 

[crislim1113]

What else would you need but to TransferSpreadsheet?

In your qryRequirements you can easily "where QueryMonth = Yourform!SelectedMonth" and all you need is to export it?

Hi would i put it in another query field or I will put it in the criteria? I am also a beginner in coding. thank you very much

 

[crislim1113]

Here is what i Did

 

[namliam]

Almost, you cannot make a full X = Y in one where clause like that.

Instead you create an (invisible) field X and put Y in the where clause.
i.e. put Year([Request]) as a field

Year(now()) as the where clause

 

[crislim1113]

Almost, you cannot make a full X = Y in one where clause like that.

Instead you create an (invisible) field X and put Y in the where clause.
i.e. put Year([Request]) as a field

Year(now()) as the where clause

ok I see. Thank you again

 

[namliam]

allowing the month to be chosen and forcing the year to NOW, will not always work. I.e. on Jan 1st you will want to see last year's december data....
I suggest allowing the year to be chosen as well or atleast think about it.

How did you fair implementing this?

 

[crislim1113]

allowing the month to be chosen and forcing the year to NOW, will not always work. I.e. on Jan 1st you will want to see last year's december data....
I suggest allowing the year to be chosen as well or atleast think about it.

How did you fair implementing this?

 

[crislim1113]

Thank you for your suggestion. appreciated it