Print report based on month and year

[bwe]

G'Day:

I am sure that this is covered in this forum, but I am not sure what to look for or where. My ultimate goal is a report, so I am starting this thread here.

I am trying to create a form that will allow me to select a program year and a month (from different combo boxes) and then print a report that will show all transactions that occured during that time.

I know that I need to base it off of a query and have it relate back to the original "Expenses" table.

What I am not sure about is how to make the query look for the month and the year.

Any help would be appreciated.

 

[bwe]

I think I got it figured out - Thanks for thinking about it!

 

[ElvenDestiny]

Well I am going to open this back up because I haven’t figured it out.

I am trying to do what I believe should be a much easier report to design.

To give a quick idea as to what I am working with I have 3 fields in the main table. Lets call these fields: Date, Status, and ID. Now I want a report that will list all three of these fields in order according to date, but only ones that do no have anything entered into the "status" field.

Any ideas?

 

[Durien512]

i am looking to have something similar done...anyone?????

 

[ElvenDestiny]

Glad im not the only one who doesnt know how to do this.

 

[nateobot]

Well I am going to open this back up because I haven’t figured it out.

I am trying to do what I believe should be a much easier report to design.

To give a quick idea as to what I am working with I have 3 fields in the main table. Lets call these fields: Date, Status, and ID. Now I want a report that will list all three of these fields in order according to date, but only ones that do no have anything entered into the "status" field.

Any ideas?

If I understand you correctly. You need to create a query that pulls in the data from your table where status is null and sort it ascending by date, then base your report off this query. Or am I missing something?

 

[ElvenDestiny]

hmmm that might just work. Let me give it a shot.

 

[ElvenDestiny]

OK for anyone who might in the future need a more in-depth idea on how to do this, you'd want to make a query like Nateobot suggested only make sure to make it a Make Table query, and after naming it and putting the 3 (or whatever your case maybe) fields you want into it open it up in design view (if you used the wizard like myself) and mark the criteria in the field you want specifically organized to "is (your criteria)" without the " or the ()'s. Then run the query should work.

Thank you, Nateobot for putting me on the correct path, seems SO obvious now that it would be that simple lol.