Search results

ahh Thanks! I guess i've been working on it for a while that my mind was going blank. I created a query and now everything is showing without having to enter them manually. Thanks!

Hi All, I am struggle a bit here and need your guidance on how to accomplish what I described in the title: I have 3 tables: tbl_activities - contains a list of activities tbl_districts - contains a list of districts tbl_districtactivities - This is the district transaction that shows a list...

Hi there, I've attached the database I created for a non-profit organization I used to work. I developed this back in 2008 so you'll see some errors there but it works. I believe it's still in use til this day. Anyway, it's a start in case you get stuck somewhere. I also attached a document...

I agree with jdraw. The way you have your table setup isn't really efficient. But to count what you have in the current table setup. You would want to setup a query (use design view) and select the table. Then select the fields (i would put the date first so you can set your criteria) then...

insert this into your field: =Environ("UserName")

In query design view, add the 3rd column Gross Cost: ([net cost]+[VAT]) For example, If your data is in table1 and you have 2 columns Net Cost and VAT, then you can use the query below to add Gross Cost. SELECT Table1.[Net Cost], Table1.VAT, ([Net Cost]+[VAT]) AS Gross FROM Table1;

Try this one: SELECT Table1.villcode, Table1.sncode, Table1.sdcode FROM Table2 RIGHT JOIN Table1 ON (Table2.sdcode = Table1.sdcode) AND (Table2.sncode = Table1.sncode) AND (Table2.villcode = Table1.villcode) WHERE (((Table2.villcode) Is Null) AND ((Table2.sncode) Is Null) AND ((Table2.sdcode) Is...

This is probably what you're looking for: Password Login Screen I hope this gets you started.

I looked at your file and I guess the reason why you're getting multiple results is that your district is not linked anywhere in the MSRequest. So I added the district there somewhere. The reason for this is because you want to identify which districts it was sent to and what size. So in the...

Thanks again for your timely reply. I will try the codes again as soon as I can. I will be on meetings for the next few days and won't be able to get back to working on this til maybe this weekend. I hope this gives me a fresh mind when I do start working on this. Thank you very much for the...

I seem to be having problems editing the code :confused: The outcome for my tables are created in queries by iif statements. Here's how I have my queries setup: SELECT tblBloodTest.RecordID, tblBloodTest.PatientID, tblBloodTest.ScreeningType AS Bloodscreentype, tblBloodTest.DateofVisit...

Ah.. Enjoy your beach house! :cool: Thanks for the heads up!. I'll double check it. Thanks again! John

I can't seem to open your file. Can you reupload without zipping the file?

OMG... Thank you very much!!! This is exactly what I am looking for! I will modify the code to work with my queries! I was pulling my hair out trying to figure out how to do this. Thanks again! John

Create a footer for both groups to get the count. Since you want to group it by district, you would want to create the header for District first and then by Campaign. To get the grand total, create a field to calculate the letters sent in the Report Footer. Your report should look like...

This is how I currently have my query setup That is correct! That is how I want the query to work. I really appreciate your help on this. Thank you! John

I am not sure what you mean by this one. I don't think there will be any null records here. A patient will always have a record all 3 screenings (FBS, PPBS, HgA1c) or just one. Not 3 months of today, within 3 months of the dates of the results. So if I look for one patient with ID 1234 and it...

The problem I am having is trying to figure out how to do the following: If FBS, PPBS or HgA1C exist, then find out which of the 3 has the latest date, If HgA1c has the latest date then show HgA1c Outcome. If HgA1c is not the latest, then find out from the two results if HgA1c is within 3...

Thank you! I knew I was on the right path since I had already created a query to show only the latest dates. But the other problem is how to address my other issue of finding out if HgA1c is within 3 months and giving the outcome of that?

Hi All, I have a very complicated (for me) query. I am working on a blood sugar calculations and have the following under Screening Type: FBS, PPBS, HgA1C. A patient can have any of the 3 screenings. Here is how my query is setup...