Recent content by csou5555

Does anyone know the maximum number of rows allowed in a table in Access 2003?

Worked!!! Thanks!! Thanks! Worked like a charm!

Join based on one table? I didn't know you could do a join when you are only utilizing one table. How is that possible?

Hi - I'm working on a query, and can't seem to get it to work correctly. I have a table which contains 2 social security number fields - one for a dependent/employee with benefits, and one for the originally insured (for example, if an employee passed away, the dependent would be on the file...

That is very odd. Is there anyway you can post a sample mdb with the table(s), query, and report?

Are you utilizing a query to generate the report? It sounds like you might have an incorrect join in a query, which can easily produce the type of error you are describing.

Create a form, containing your drop-down, start and stop date fields. At the bottom of the form, place a button that will open your report. In the query that generates the report, for each of the fields you want limited by data from the form, enter something like the following in the criteria...

Thanks everyone!!! Thanks for your help!!!

I have a report (based on a query) that generates a list of all the work projects completed within a user-defined date range, with all of the cost information associated with each project. In the report footer, I have a control that calculates the sum of all the projects on the report (control...

I have a report, which is based on a query running against a table in my database. One field in the table contains hyperlinks to word documents (billing) on our server. When running a query against the table, the hyperlinks are still active in the query. However, in the end, the hyperlinks...