Search results

Scooterbug - Thanks for your input. I agree multiple storage of same data arross tables is bad. The schoolID is being stored with on the Student record, field "Child School" in the form of the School name. For all the reports they DB owners should join the tables together. The users like to...

i do not know the age - i am not related - i thought it was a kool picture so i use it here and there thx

I have a access db with 2 tables. Student School When adding rows to the Student table for the field School the selection is a drop-down list. I want the school address to automaticly populate the Student table for the field School Address on the Student table. Is this...

I have a report that has 9 sections. I export to PDF and save it to My Documents and then email. A new requirement, is that each of the sections is a separate document to be email. I could break it apart to 9 queries, run the reports entering a date range 9 times then saving to a PDF file...

I have it figured out. The number was coming in as a Percentage. I changed it to a decmial an formatted it as a percent then it worked! Access could Not average percents too complicated...

I have a set of details with percents and want a total with an average of the percents. I would think you can have an average with a group break using the average function. I cannot get it to work. Attached is a screen print. It is probably as usually a minor syntax error in the...

Found it a use a expression with a function like this. GREAT! Expr1: DateAdd("d",90,[DateofConsent])

I have a date and a number of days in the future from the date. I need to display what that date will be: i.e. I have the Start-Date 05-29-09 I need to show the completion date: i.e. + 90 days = 08-27-09 I know the +90 but not the 08-27-09. How can I do this in Access? Thank...

I got the formula here it is: WKLYF2F: Round(IIf(([ACTIVITY TYPE-SA]<>"Travel") And ([RATE VALUE]="1") And ([DATE-SA] Between [Start Date] And [End Date]),[TIME-SA],"0"),2)

Re: Instead of joins/unions - add new wkly fields Probably the best would be to create a subset of weekly total fields within the lifetime query pull of data. This is will be little a little hairy for the selection for a weekly-amt that is come from a user-entered parameter. For example...

For both queries I excuted another query to sum and merge up the data. Same set of tables at the root. Yes, all the last-week-data is in the life-to-date-data. Life-Cases - Last-Week-Cases 101 .......... none 102 ...........none 103............103 - Match 104........... none 105........... 105 -...

I have 2 queries and need the data merged. One query I pull the life-to-date data the other I pull last-week-data. I need the output of both queries merged on a report. There always will be a match on a key field from the life-to-date-data to the last-week-data (family-number)...

SOS - Thanks for sticking with this tricky formula. I am sure I will run into more situations like this with what I am doing now, I do enjoy good results thou. Have a good day, and kudos to you and your Access knowledge. Russ - Data Specialist Manager at www.scanfw.org.

I will try your solution today and let you know. Thanks Russ

Re: Expression with multiple parameters - zipped db I just put the needed tables and part of the data there, the query within the db is attached. Russ

not too easily size and confidential data

I tried it like this no luck?? FaceTime: IIf([ACTIVITY TYPE-SA]<>"Travel" And [RATE VALUE]=1,[TIME-SA],"0")

SOS - Yes, I squeezed the columns to keep it all in one window. Attached is another snapshot. Russ

SOS - your good code passed the syntax test but failed to deliver the data. The query ran smooth but the result is an ugly "error#" instead of amounts. Can you fine tune the code some? Thx Russ attached is a snapshot

My error message is the "wrong number of arguements". I am trying to create a new column with two criteria being met. 1) The column "Activity Type-SA not equal to "Travel" and 2) The column "Rate Value = "1". FaceTime: ((IIf([ACTIVITY TYPE-SA]<>"Travel") AND ([RATE VALUE]...