Export button

crislim1113

New member
Local time
Tomorrow, 05:38
Joined
Jan 27, 2021
Messages
19
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

1611739162986.png
 
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?
 
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
 
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
 
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
 
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?
 
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?
 

Users who are viewing this thread

Back
Top Bottom