Search results

HI, I've just been asked to add some information to a database I have partially built and would appreciate some suggestions on how I should go about it. Currently for exisiting projects I have a table that contains fields for up to 12 payments, for each of those payments I also have a related...

tabbed pages various record sources How did you make out David? I've been trying to figure out how to do the exact same thing. My problem is the amount of data from the various tables is so big that I don't want to put it all in one query so think I'll have a try with the subform approach.

HI, I am building a database that records information surrounding grant monies given out by the department that I work for. Each grant is recorded as a project with an ID and description as well as the organization it was given to, the amount and various other data related to the grant. Some...

Thanks for you reply. I don't think it is the amount of controls as there are less than 20 on the entire report. As for format, I copied the control that worked and just changed the syntax from GrantAmount to ConsultantFee so the format should be the same.

Hi, Last year I found a report somewhere on an access help site that would show a timeline. I copied the report into my Access 97 database and it worked fine. I tried exporting this report to my current Access 2000 database but it keeps coming up with an error. The error section that is...

Hi, I'm am trying to figure out how to do calculations for fields in a report. I've managed to get my report to show Consultant Project GrantAmount ConsultantFee Data Data Data Data Data...

Hi, I have a table of Organizations that I use a 5 letter code for the ID field which is the Key Field. I have a query on the Organization table and from that I built an Organization Form to make entering the information easier. The 5 letter code usually involved the initals of the...

thanks Pat - Thanks very much for the reply There are some zero balances as not all projects have the same amount of payments. I tried the expression and it works fine.

Hi, I am building a database and would like to create a field in a query that totals several other fields. I haven't done any calculations before but understand that they can be done and the best place to do them is in a query. I did a search in this forum but could not locate a problem where...

Thanks Tim, from the help it appeared that the DESC would be inside the brackets. It works fine now. I take it Year is a bad name to use, thanks for the warning. I'm still working on building the database so it is not to late to change the name.

I have the following lookup statement SELECT DISTINCTROW [Year] FROM [Year] ORDER BY [Year DESC]; I have a PROJECT Table that I need to indicate the year that the project commenced. Once all of the historical data has been input, the most frequent year used will be current year. My YEAR Table...

I have a database with several tables. I have ID fields for most of my tables. In my main table I have a field called GranteeID. Rather than have the ID number appear in the table I would like the Grantees LastName and FirstName to appear. At prestent in the Row Source box I have keyed in...