Search results

Thanks for writing so quickly! Answers below. How do you run them now? Manually, by double clicking each one. Do you have the queryNames in a Table? No Do you always run all queries? Yes, all the Append queries with the similar names (AppendCriteriaXXX) are run monthly. But sometimes new...

I'm using Access 2003. In my database, I have over 300 queries. Out of that, I have 150 Append queries that I run each month. Because of the way they are named, they are in position 2 thru 151 in the query window. (They are named AppendCriteriaCostY4; AppendCriteriaScopeR8...

Thanks to both of you for writing! The data is dumped from a web-based application. Ted: The web-based application is where the user enter the data, so I can't do AfterUpdate code or add fields to the table. But that was a good suggestion. Neileg: Good point about normalizing. You're right...

I received advice today from someone who gave me the following formula that can be used instead of the nested IIF statements or the Switch statement: Fiscmonth: IIf(DatePart("m",DateValue([LastFullMonth] & " 1, 1900"))<10,DatePart("m",DateValue([LastFullMonth] & " 1...

There are 2 types of paths a project can follow: ELC and SDLC. In my database, the user must choose which path they are following for their project. Once they choose a path, they must then fill in one of the two appropriate grid with dates. The two grids have around 40 fields each. I am...

I didn't know about the Switch Function. Thanks! I typed: Switch([Project Status Survey Budget]![lastfullmonth]="October",1,[Project Status Survey Budget]![lastfullmonth]="November",2,[Project Status Survey Budget]![lastfullmonth]="December",3,[Project Status Survey...

I am trying to write an Append query that has a math formula. Part of the formula is to look at a text field called LastFullMonth (contains values such as January, February, etc) and do a calculation based on how many months have elapsed since the fiscal year. (the fiscal year begins in...