Recent content by jaxhere

This will also work: SELECT Table1.Field1, Table1.Field2 FROM Table1 WHERE (((Table1.Field2) Is Not Null)) OR (((Table1.Field2)<>""));

I'm not sure if this would work, but it seems to me that you might try doing a previous query where you'd use the DISTINCT operator to select unique values, then do your SELECT TOP 3 query on the results of the previous query.

To me, your request reads like you want to get someone to do your homework assignment for you.:( If you haven't a clue as to how to do anything on the assignment list, you should maybe start by reading the basics of Access which are available in the Help file in the program itself. :) On the...

Thanks, Minkey. I knew there was a simple solution, but I simply couldn't discover where it was. You've helped me get rid of a tormenting little annoyance.

I have run into a little snag which is bugging me and wonder if anyone here might know the solution. XP 's Windows explorer has a feature to show files in Groups when you open up any folder. It seems that this is the default for the program, but if you click on the View menu you have an option...

I downloaded the sample database in http://www.access-programmers.co.uk/forums/showthread.php?t=105243 and have figured out how to use it, however, I still have a puzzle. In the Visual Basic code window there are two Microsoft Access Class Objects shown, one for the Form_frmInfo and the other...

Making progress- can now combine different data types I've made some progress in my project which others might find interesting if you need to produce a report which included two different types of documents, one of which you need to report in detail, and the other which you need a daily...

Not quite what I need Ziggy, your solution doesn't seem to produce what I need. I've modified your proposal to show what I want in a sample table called tblResults and also a report based on that table. In the zip file there's also a text file with a bit more information about what this is...

Thanks Neil, I've seen this and downloaded a sample. It's not exactly a QB clone and lacks some of the functionality I'd like to find. So if there are others around, I'd like to check them out. Regards, Jack

Maybe I started with a problem which was badly stated, so I'll try to break in down into separate steps. To start, how do I set up a query to report the lowest invoice number, and the highest invoice number with the same date, and show me a total of the amounts for that day. Suppose my initial...

don't want spanish QB Yes there is a spanish version, but it is, to my knowledge a long outdated version and has never been updated. Further, I want some modifications which an Access-based program would allow me to do.

I'm looking for an Access based Accounting application which is similar to or better than QuickBooks, but which operates in Spanish. Does anyone know of any such application?

I'm a bit new to Access and need help setting up a report based on a query. I have a table with the following fields Date DocumentNumber Client ClientIDNo SaleAmount Some of the DocumentNumber data is strictly numeric, some have a prefix "F" What I want to do is the following: For each...