Search results for query: *

Thanks for the response: I tried it and similar formulas, but I am using a total created by pivot and the 'getpivotdata' comes up and makes the cell absolute ($a$1) and I can't copy down the column. I tried + then moving to first column, then the - and moving to second total. But I don't want...

I created a pivot table from one sheet that included all invoices from 05 & 06. I have Cust/Mfgr/prod in the row fields. I put the ;'idate' and 'amount' in data area. grouped by year. Now I have 3 columns: 2005 sales, 2006 sales, and grand total. I want to subtract 2005 from 2006 totals to...

YES! It worked. Thank you!!!!!! mmsales

Thanks jebry for this answer. Can I take it one step further? How can I get access to ask me the mfgr (ie: adv)and still have it look in the 'multi entry' field. I tried "like "*[get mfgr]*" and it gave me all of them. I am trying to print a list by mfgr. thanks in advanced, mmsales

Could not get to work. Is there a way to do it using the query grid?

I have imported an excel sheet to a table. One column has multiple entries separated by commas.ie: blum,adv,epi,kl How do i get access to give me records that contain 'adv. FYI: some records have adv only in the field. I could get those with single entry, but need those with multi entry. Thanks...

I am making a report for april invoices. In the title I would like the month to be spelled out - ie: april 04 not 04/01/04. I query the dates to pull up all april invoices. If i put 'idate' field in title, it shows up as 04/xx/04 (what ever the first invoice date is). Thanks mmsales