Recent content by hopkins

:eek: I can't get the file small enough for the forum to accept (minimum I can get it is 1148928 kbs

Oops... in orde to meet the criteria I set use the following when it asks for collators: First criteria: 21300 Second criteria: 21301 Third criteria: 21305 Dates need to be entered as well (I haven't figured out how to make them non-mandatory): use 04/01/2003 and 04/30/2003 Again... thank you!

Here is the zip file (273 kbs) When you run the "Detailed Project Report" report you will notice that the first 2 records result in the same "Financial Code". The financial code that shows on the 3rd record should actually be on the second record, and everything after that moved up one record...

Basically... The report was working correctly until I added a new field and included the field in the query, now it seems to be off just a bit. It is hard to verbally explain - the report returns a separate record for each project code. There seems to be a glitch in the querey which uses the...

Sounds in-depth for a novice user such as myself, but definatey a challenge I am willing to take on. I will work on this over time and possibly will be back with questions, although I do see some posts in this forum that address the issue. Thank you!

I have a set of criteria that require user input when generating the query-based report. 3 for entering the project number a user would like to search [Enter first collator] Or [Enter second collator] Or [Enter third collator] Only the first collator needs to be entered to have a successful...

The "header" in my report pulls informaitn from a query to sort expense information based on Responsibility Centre and project code. When the report is run the first 2 projects have the same number which then puts the remainder of the projects one-step out and they don't macth up woth the...

I have a need to allow multiple users to have access to the same form, but restrict the information they retrieve from the database via reports. For example, my "transaction" table records all the information regarding the different projects I track expenses for. There are 2 managers who, based...

I guess sometimes it's just the easiest things! Yes... that works. In a query such as this is there a way to use a point-and-click calendar? Thank you!

I have mastered forms and simple reports, buut now a querey seems to have me bogged down. Following is my "Transaction" table: TransactionNumber : AutoNumber AllotmentCode: Text (Look-up from separate table) Business Line: text (look-up form separate table) Resp Centre: Text (look-up form...