Search results

Hi Just remove Bound.

Yes, they are there. Check this site: http://www.teacherclick.com/access2003/t_12_3.htm Go to "The report design bar" You need list of fields box

Hi, I presume you are in one table, and want all contacts from 1 business? In table display mode: Right click on the field containing the Company. Then from the menu that appears, select "Selection Filter".

Hi, You can find the fields in the report design view: Menu... View... List with fields. Now add the fields with "Drag and drop"

Hi, [Type of comp] is the drop down menu? If yes: In your Macro condition, you are trying to refer to a text field within the drop down, while most likely the stored value "bound column" of the drop down, contains the number auto number. So that will not work. In the macro try...

Hi, Perhaps it is a good idea for you to practice reports by using the "New-Object" Report wizard. Try the "Wizard report" option, select the Final query, then when done, view the report in design view to analize it. I'm sure you'll learn a lot from that. You could also mail me screen shots...

Hi, I understood that: - You have 1 query that is working fine in the display view (even though you use the SIGMA to totalize in view mode). - You also have a form with date1 and date2. - The query reacts to the dates on the Form correctly in view mode. If this is all correct, then I presume you...

Do you know how to create a report from your query? If yes, then read my previous thread. If not, then I suggest you learn to create a report , and in design view add the query. Then add the $ field to the details section, then read my previous thread.

Your Question1: "So I could then with the subforms add as many services as is necessary to the physician table due to the "1 to many" relationship I have created, correct?" My Answer: Yes, correct. Your Question 2:"If a table will have more than one entry of the same thing (like a Physician will...

Dear Neo-fite, A question is never stupid. Not asking is! I'm presuming that you can create a report from the query, and you have the fields that need to be calculated, in the "details" area of your report. In your report design view, add a "Textfield" (looks like "abI" in the workset) in the...

Hi Saelin, I would relate 2 tables to your Physician table :Facility and Service. So in Tbl Physician I would delete FAC_1 till FAC_3 and Serv_name1 till Serv_Name3. Instead add IdFAC and IdService. These new fields must be Numeric / Long integer. Then make relationships "1 to many": - FAC_Id...

Hi, My name is Gary. Fantastic Forum. I'm sure I will visit frequently:p