Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RobertSanders
- Order by date
-
Personal Fund Manager
O yeah, to make it more visual you can download the db here: http://members.lycos.nl/robertsanders/Expenditures.mdb (1.2 Mb) the query where it goes wrong is called PROBLEMQUERY. As you can see it tries to combine the queryresults from the 'Total'-queries. These queries do give the proper...- RobertSanders
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
Personal Fund Manager
Hi, I'm trying to create a personal fund manager, but have the following problem. The db contains 3 tables: -Users -Expenditures -Income 'Users' contains the users 'Expenditures' contains expenditures per user, with a expenditure group (Look-up field) 'Income' is the same as expenditures...- RobertSanders
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Two personnel members in 1 query, HELP!
As is said before every personnel member has a functioncode [Function ID] assigned from a table with a field called Function group. The SQL is as follows whereas [*FORMULA*] stands for the formula used to calculate the Grade field SELECT Roomchecks.[Roomchecker ID], Roomchecks.[Cleaner ID]...- RobertSanders
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Two personnel members in 1 query, HELP!
While making a dbase for a housekeeping department of a hotel I stumbled on the following problem. I have a table called personnel, with every member of housekeeping in it. Now the dbase also has a table with roomchecks. In these roomchecks, there is always a field checker and cleaner, whom...- RobertSanders
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
