Search results

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

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