Search results

File is attached as per your requirement Check the query "YourRequirement"

Make a temporary table from selected data and then main table with data from that temporary table

Try union queries

SELECT Table2.ename FROM Table2 in 'F:\database.mdb' ;

Query works on only two month but in your case it spans over more than 2 months for this you have to write vba code

Below is a sample attached for you

Try this TRANSFORM Count(CCF.CCFNo) AS CountOfCCFNo SELECT CCF.CustomerACNo,Format([RaisedDate],"yyyy") FROM CCF GROUP BY CCF.CustomerACNo PIVOT Format([RaisedDate],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

your where claus will be some thing like this where location in(2,3)

Use running sum in report it is the place where you can handle this type of things better

upload sample database

Check my post here it will give you some idea

Check the attached file Employee A has reward and employee B doesn't have any but query shows both employees

You can use an option group on the basis of which it can be decided which report to run

Try this one its more flexible http://www.access-programmers.co.uk/forums/showthread.php?t=170431

not in(20,30,40)

Use another query and select distinct dates from first query

A quick sample to add extra dates is attached I have just added one table with one field Check data in the table first then open query "RequiredQuery"

Yes it is possible use attachment field as row source of listbox

Opening balance is a balance before some selected date you can easily calculate it using query

Can you describe your table columns