Search results

Pat, Thank you very much. You are right. Changing the control names fixed the problem.

Wayne, In the better late than never category......... I haven't been able to work on this problem for awhile. If I haven't figured out how to do it when I get back to it, I'll probably post another message / question.

I have a big query with many fields that several reports are based on. A bunch of reports work fine. I have a new report where some of the fields in the query wind up giving me #Error instead of the value that is in the query. By testing I discovered some fields don't like when I use...

Never mind for now. My "first" and "last" queries now seem to work by using "first" for the month and sprg for the "first" query, and by using "last" for the month and sprg for the "last" query. I may have problems combining (I guess, appending) the records from the "first" query, the "last"...

I thought I figured out how to start the 2 query theory until I realized my test coincidentally had the smallest sprg # as the earlier records. I used "min" and "max" in the 2 queries and things seemed okay, but I think they were okay because of the coincidence. I then changed my test...

I have a query that has, among other fields, name, sprg (short for subprogram), date, and a calculated field called InsJan. There will be 1 record for each name/sprg combination. If there’s only 1 sprg for a person, I don’t have a problem with InsJan. But if there’s more than 1 sprg for an...

Wayne, Thanks for all your work! I was able to open it. I haven't been able to learn as much as I'd like about Access and VBA, and thus I don't understand everything you did. I guess I'll be able to adapt your code to take into account around 50 SPRGs (I only used 2 SPRGs, 5210 and 5310, in...

Wayne, After unzipping the db, I tried to open it. I get a message saying "unrecognized database format." I'm using Access 97. Did you save it as another version? Regarding the large query, I couldn't figure out how to do it better, and that's how it ended up. And that's after a few...

Here's a zipped sample of the database. Most of my tries from the past couple weeks for getting the correct subtotal are gone. I got tired of looking at them days ago. If you can find where I should put the default values, or any other ideas, that would be cool.

Wayne, I tried pasting the Data tab here in my reply, but it doesn't let me paste it like I could in Word. I cannot find an option for default values anywhere in my property sheet for these unbound textboxes. Earlier, you mentioned something about initializing the values. How can I do that...

Wayne, I thank you for all your help and putting up with my questions, but on my Data tab in the property sheet for these 2 unbound text boxes in the report footer, I just have 3 options - Control Source, Input Mask, and Running Sum. I've looked in the All tab, and couldn't find anything about...

Wayne, I don't know if this matters, but I have Access 97. I deleted what I had in the control source. I should've mentioned earlier that, even after looking in help where it said DefaultValue was on the property sheet, I couldn't find it. I've seen it elsewhere in Access, but not on the...

Wayne, I guess I need more elaboration. I think I understand what you're trying to say, but I don't know how to do it. I created 2 unbound textboxes and named them like you suggested. In the control source I did =0 and =" ". But I'm not sure that's what you meant. I created a 3rd textbox...

That was one of the first things I tried. That added up all the records in the query, which is more than I wanted. I just want one occurance (which would be one record) for each sprg to be added.

I have a report based on a query (which is based on other queries and tables). The output of the query has a record for each employee and subprogram (sprg). Each sprg has more than 1 employee. All but 3 of the many fields come out okay on the report. The report has detail information for...

Is there a way to change the font of the code in the SQL View in a query? It's not very easy to read. To make the code easier to use, I use a lot of carriage returns and have fields line up where possible. However, when I close the query, those carriage returns dissappear and all the code...

I have the following code in a query: HAVING ((([enter 1 or 2 digit fiscal month])=[enter 1 or 2 digit fiscal month]) AND ((tAllYears.DisbMonth)<=[enter 1 or 2 digit fiscal month] Or (tAllYears.DisbMonth)="prior")) OR (((tAllYears.RecMonth)<=[enter 1 or 2 digit fiscal month] Or...

I figured it out by using "=Sum(IIf([DisbMonth]<=[MonthSelected],[CYNetDisb],0))"

I have a paremeter query which gives me correct information - one or more records, per month, per contract #. When I run the query and enter "1" for the month field parameter (not shown below, but meaning I want all records which have a DisbMonth of 1, or a RecMonth of 1) I'll get the following...

Thanks for the suggestion to step through the code. When I did, it shows the value of rs!federal and rs!deffcomp for the first record. I don't know how to step through the code to read other records, which is basically the problem the query is having with this function. I took out some of the...