Search results

D/ALL I have all but finished a project till this multiple conditions for a sale_amount expression came up. 'saleamt' expression in a query has many conditions based on three fields. For example: 1. field1: two types of products: 'itemA' or 'itemB' 2. field2: two types of sale: 'free'...

D/SIRS I got two tables one with staff names and other with various duties for emergencies. I made a 'job-dtls-table' with fields name-code from staff-table and job-id2. I made a main form with 'job-dtls-tbl' with subform which exhibits 'job-tbl'. I select the name on main form, control...

D/Sirs Thanks to overwhelming guidance from this forum, successfully completed staff table with products table, the required queries and reports. Now I have one table with staff details called 'staff-tbl' and another table 'job-tbl'. The jobs are for various emergencies and to designate a...

D/Sirs All going good and now I am on to a bit of lipstick job and sprucing up on presentation. At present I have a separate form to select a staff and do the editing of all the data. Would be nice if I can get help for the following: I have this multiselect listbox. Is there a way to do...

D/Sirs It was all fine with checking sales for staff; to enter new staff for sales; to enter unknown names etc., with a main and sub form (in the orders entry sample). When I tried to limit the data to current month, I have altered the record source on the main form to a query. All went wrong...

D/Sirs For the sales, I have made a table sale_details. When I use this table in the main form and item purchased in sub form, I get the full records. Is there a way to restrict the table to show only for the current month? I learnt to do that using a query and using the query in the main...

D/Sirs I made a table with known and unknown names. To identify sales to unknown, I put a category field in products table with three categories 'staff' 'agents' and 'owners'. When I created the field I used the look up field and used the row source as 'value list' and entered in row source...

How to deal with a known and unknown list of names? D/SIRS I have completed the tables, queries and reports to a major extent thanks to this forum. Pity is that after I have almost completed the project, I realise that I have two sets of people. One is staff list and another is unknown...

D/Sirs Thanks to this forum and thanks to mr boblarson, mr. hitechcoach, mr. bill, and mr namliam I have started from scratch and managed to link names table and stores table and got going on various forms and queries successfully. Now I am onto the reports to make sales report and stock in...

D/Sirs I got the three tables 1. crew details; 2. store items details and 3. crew sales tables which has saleid, name_code, item_code etc. The above I got something constructed on the lines of 'orders entry' for the crew who purchase stores. I am able to see the various sales for each record...

D/All I managed to put combo box with names and got the macro to show records for the selected name. Can any one tell me how to put a condition in this macro to get a message box to inform "the said name not found" . brgds/captgnvr

D/All Some time ago I got help from this forum and this below code works fine to get all the data for the selected crew members from multiselect list box. strSQL = "SELECT * FROM TBL_CREW " & _ "WHERE TBL_CREW.NAME IN(" & strCriteria & ");" ' Apply the new SQL statement to the...

D/ALL 'THANKS TO THIS FORUM', In the last 10 days have started from scratch and managed to make tables, forms, queries and report for crew and items sold. I am stuck in my last lap i.e: 1. In one query "Q_SALES_QTY" able to get various staff buying various items as sum of quantity sold in the...

D/All I hv made lots of progress thanks to this forum and 'hitechcoach'. I have staff tables, items table and effected some sales and purchases etc. Can I have a link to read up about: 1. How to keep track of opening stock? 2. How to keep track of monthly sales and purchases? 3. How to...

Dear All First table with names. second table with store items. I read the northwind for preparing invoices which does not fit my requirement. Pls give me links for me to read up on how to prepare report on persons who have made purchases by linking these two tables. Pls give any links...

D/All For example: first batch joined on 10th, second batch on 20th and third batch on 30th of the month. In each batch certain persons will also leave. What is required is: 1. query for full persons list as on 9th 2. query for those who joined on 10th, another query when second batch and...

D/All I have linked excel 97 to access97 data to get list of crew members. It works fine from the computer where I have programmed and where the excel file is also on the same comp. When tried to give demo from another network computr get odbc error message. I read thro lots of articles to...

D/All Crew list in excel is linked to access database. I am able to filter data in two queries. one will have crew members as on the beginning of month and another query which will have crew joined during the month. Could you pls tell me how to append the newly joined crew members query to...

D/all I have a list box in a "info_form" to multi select names to get their particulars. Once a person leaves, his record is deleted using another form for deletion. When I come back to "info_form" I see in the list box "#deleted" for deleted records. If I go to the row source type and run...

D/All Using A97. Request for patience as not too knowledgeable for this particular problem of mine. Gave it up for lack of guidance and again starting it with renewed encouragement from this site. Have two tables, one with crew data and another with store items. Too many road blocks and lots...