Search results for query: *

Thanks Ginger for your help! I deeply appreciate it.

Thanks Ginger! but how does the ClinicDate in ClinicDates is populated? With your solution it does not get populated automatically through the visit subform. Does the user have to populate the ClinicDates manually? I would want the ClinicDate to populate when the visit table has records for a...

You are right on your logic, but my scenario is a bit different with various assumptions. Your logic is more accurate and takes in consideration of fixed/variable expenses. Unfortunately, the requirements given by the clinic is different. They want to store daily expense/revenue information...

The accounting data is not specific to the visitor. Its relevant to the clinic for each visit day. The data that goes into ClinicAccounting is as follow: * Amount of money spent on stationery (expense) * Amount of money spent on rent for special meeting (expense) * Amount of money for catering...

Thanks Ginger! I have created the database in the same exact design as you had recommended in your post. I have one minor concern/issue. My concern is with the ClinicAccounting table. I want the clinicAccounting to store information based on the visit dates. For example, if the patient visited...

Hi All! I have been given an assignment by local church to create a small database application to to track and report daily clinic visit information. I have design the tables to capture visit information of patients. But I am having problems with the designing of the database to include clinic...

I apologize for not being clear and articulate in my prior postings. Let me try to explain the situation. Lets say I am getting sales data from different sources. Each source has the priority assign to it. If the data is missing, it should look at the second priority and find the missing...

This reason the Houston record is showing Comm:132 and Comm_Source:Perry is because it is the second priority. Morrison and comm:100 is the third priority of data. Below is the table of source priority. Source_ID Sales_ID Priority ADAM NEWYORK 3 CHRIS NEWYORK 1 DEBBIE...

That is right Marsss. There is no comm data for Chris and debbie does have the data (and also second in the priority). Thanks!

Thanks Marsss for your solution. But your solution does not incorporate the priority feature of data source for both sales and comm. Further, my output should not be dependent on the max value. It is dependend on the source priority as I defined it in the source table. Any thoughts/feedback? :o)

Leslie I tried the cross tab query and I could not get the results as I desired. Can you help me in this regard? Thanks!

Hi All Can someone refer to me a article or any website that teaches Multiple Sub Forms in a main form. I have couple of books, but they only give example on simple Parent/Child form. Let me give you my scenario. I would like to create a form that will use a combo box to select the patients...

Thanks I will try using cross tab query and see whether I can solve the problem. Thanks!

Yes I can join the tables together on the Source_ID and sort by Priority, but this will give me muliple records for each sales ID. For example, It will give me three records in the query instead of one as mention below...

Hi All! I need help in design of a database table. I have a Sales with the sales information coming from different sources. I need to priortize the output in my query to what I define in the table. Let me explain this via table structure. Lets say I have a source Sales Table as below...

Thanks! It worked perfectly :o)

Just for clarification... Can you give me some sample numbers/values for the Input Period? I am still not following your condition in the SQL. What should be the value of Input Period if I want the result to be in quarterly basis? What should be the value of Input Period if I want the result to...

Thanks for your reply Tony! I tried the formula, but it gives me an error on Input Period. What should be the value of Input Period? Should it be Q for Quarter or Y for Year or should it be numbers....

Thank you for your prompt feedback KS! Actually, my query results can have records for twenty years and plus. Your solution works fine for fewer period (records). Can you tell me how to write a SQL statement that can simply skips record based on Quarterly or Yearly or Semi Annually basis? For...

Hi All! I have a table in below format: Dept_ID Expenses Date ACCTING 12000000 6/30/2000 ACCTING 10000000 7/31/2000 ACCTING 20000000 8/31/2000 ACCTING 30000000 9/30/2000 ACCTING 50000000 10/31/2000 ACCTING 60000000 11/30/2000 ACCTING 70000000 12/31/2000 ACCTING 10000000...