Search results

Pat, Could you tell me a little more changing the tables so I don't have to 'do this normalization "on the fly"'? I've been reading about normalization. I'm not sure it will work in my case but I'll do some testing. Thank you! I appreciate your suggestion and input!! [This message has been...

In an append query, I can only append one amount field from table1 to the amount field in the temp table. So say from Table 1 I need to append ID, start date, end date, amt1, amt2, and amt3 to the temp table to the fields, ID, start date, end date, and amount. I can't append amt1, amt2, and...

I need help with a complicated set of queries. I have 4 tables, each have a start and end date and they have either 8 fields or 12 fields for an amount. If the start date <=Date() and the end date >=Date() then I need to pull some of the amount fields and insert them into a temp table. The...

There have been several posts that are similar to what I need, kg20079's was really close but I need to open a query instead of a form. To start with I have a table which have 15 fields, 12 of those fields hold currency which represent each month of the year and are labeled by month. I have...

Raskew, you are great! This works wonderfully. Thanks for the help!!

Thank you for the reply. It does look like I was needing quarters, hadn't even noticed that. Unfortunately that's not what I need.

I've done a search but didn't find exactly what I need. From the startdate field I need to calculate: If the month of the startdate is 1,2, or 3 then show ("yyyy",[startdate] & "1", if the month is 4,5, or then ("yyyy,[startdate]& "2", or if the month is 7,8 or 9 then ("yyyy",[startdate] & "3"...