Recent content by mgonzales

I tried it but it didn't work. Is there a formula that I can place in my report that would consolidate the duplicates and still show a total? I am not using a query to get totals, I have placed formulas in the report to get the totals that I currently have. Right now it shows like this in my...

I have a report that has groups and sorts. It sorts by course then by organization. This grouping also contains cost information, priority, and total # of participants. When an organization places the course twice I need my report to rollup that information into one line item and just add up...

Worked! Thank you!!!!

I have a table that contains a few fields that I need to create a report by grouping and sorting fields in certian ways but I can't figure out how to do it. I think I need to create some type of query, but I cant get it right The fields are Header, Course, Group, Total Need, Cost, and...

Thanks I have called my network admin.

Is there a way to recover a previous version of my access DB. I accidentally deleted information from the DB and need the DB to be restored to the version I saved yesterday. Thanks!

I am placing the statement in a single field, not across multiple fields. so if i have what is below, what would I get Values in a single field: 900*, 774*, 556 Statement: not like 900* and not like 774* Statement: not like 900* or not like 774*

Thank you Higg, so what your saying is..the "or" statements would still pull some of the info that I dont want? So then the "and not like" statements would be the way to go? Thanks

What is the big difference between the "and" and the "or" statements in when using them as a parameter in an Acces query? I'm using it to filter out data that I don't need, so I am using "Not Like --- and Not Like" i am also trying "Not like --- or Not Like" They are both pulling data, but...

I am importing an excel file into a table then the report is based off a query that pulls info from the table. What I have noticed is that the report will only work if I get an error message when importing the excel file. If I do not get an error message then the report does not work. The...

Yes Total Cost is the field name from the query.

The only equation I have in the report is this =Sum(Nz([Total Cost],0)) I do not have anything else, the rest are just text or currency fields.

I keep getting this error message when I open my report. My report works for all my others that have the exact fields. What does this error msg mean? "This expression is typed incorrectly or it is too complex to be evaluated"

what would i look for in the source. I don't understand what it means

I keep getting this error message when I open my report. My report works for all my others that have the exact fields. What does this error msg mean? "This expression is typed incorrectly or it is too complex to be evaluated"