Search results

Hi there, I have a query that returns rows a row of data everyday for around 500 clients. The first field is the extract date. As the data is monthly cummilative I would like to set a criteria for the last day of the month...what ever month or year that may be in. Is there a simple...

Hi, I have created a pretty simple database to calculate sales commissions. One of the areas is on deal volumes. The BDM will get more commission on his/her 16th deal than their 15th. As such I need my query to number the each deal. I think this is essentially ranking, but I cant figure...

Hi, I have created an union query to pull together the same data from 2 ODBC tables (seperate countries). As there is a clash in the client number I have added a "N" prefix to differentiate NZ from Australia, as below: The problem I now have is that I get type mismatch when linking to...

Hi all, I set up what I thought was a simple query in my DB using it to create a report containing a subreport. I kind of works, however Access is asking me for the parameter value [Extract Date] multiple times, when in theory it should only ask once! In addition (and likely related) the...