Recent content by cooh23

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...