I would say I am a low intermediate user of ACCESS and looking to become an expert user since this is an upcoming requirement of my position. My company will...
Check out AppDev.com Also, your local junior college usually has certificate courses for Access. Best way (imho) is to learn VB and/or .NET and dig in!...
I suggest that you try the following links and from amongst them select the ones that are meaningful and helpful to you BEFORE you go on a training: ...
DEARS I have a query having filed name factories in text data type and result of query like follows Plant A Plant B Plant C Plant D Now form above query i...
Look at MS Access help at the "cross tab query". This may be what you are looking for. May God bless you beyond your imagination! Lonnie Johnson ProDev,...
Some Internet surfing has shown me that Microsoft Access can be companies fully integrated data system. Where can I learn all the stuff Access can do? I use...
I believe Access and Excel can do most anything but you can't make it "walk the dog" unless you know VBA. Feel free to check out my very active Excel group at ...
Please check out the following also: http://tech.groups.yahoo.com/group/ms_access/message/21446 http://tech.groups.yahoo.com/group/ms_access/message/21395 ...
G'day to all I am new to this group and have a problem.... I have been given a table with 80,000 records and have been advised that there are approx 5,000...
You probably can make a query that builds another table, selecting everything from your table, but not duplicated rows SELECT DISTINCT MyTable.* INTO NewTable...
Hello, How do I compare data from two tables and display the results of the inconsistencies in a screen? Thanks. L y a n n e R h e e z a C. O n g [Non-text...
Using Access 2003 Trying to join the following two tables: TABLE 1- this is a reference table that lists census block groups and associated zip codes within a...
On the query tab of the database window click New and then select unmatched query. That will get you started. May God bless you beyond your imagination! Lonnie...
Hello, I would like to automatise the building (and saving) of 200 queries. The queries are based on one table only. They differ from each other only by the...
Thank you very much Lonnie, your code with the comments on each instruction is the VBA teaching i need ! GC [Non-text portions of this message have been...
np. Let me know if it works for you. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit...
Hello, In a select statement, how do you get the value of "TES_1MGMT - ALL_SUBMIT" from a sample field value of AddUserToUserClass,"ADSEN, Audun","TES_1MGMT -...
Not sure what you mean here. Is AddUserToUserClass a table or query? What do you mean by a sample field? May God bless you beyond your imagination! ...
If there are not a lot of columns to convert you could do a union query. Normal query "SELECT " May God bless you beyond your imagination! Lonnie Johnson ...
Sorry. I hit the send button by mistake. If there are not a lot of columns to convert you could do a union query. Normal query "SELECT COLUMN1, COLUMN2...
Sorry. I answered the wrong post before. If there are not a lot of columns to convert you could do a union query. Normal query "SELECT COLUMN1, COLUMN2...
AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is a field value. Through a select statement, how do I get 'TES_ 1MGMT - ALL_SUBMIT'. To...
Ok. Forgive me if I sound dense but AddUserToUserClass, "ADSEN, Audun","TES_ 1MGMT - ALL_SUBMIT" is the value of just one field? Is it always formatted the...
Yes, it is a value of one field. Yes, it is formatted that way - always separated by 3 commas. L y a n n e R h e e z a C. O n g ... From: Lonnie Johnson...
Try this... http://www.tek-tips.com/faqs.cfm?fid=37 May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
