Search results

Thanks, Paul. Sometimes all a person needs is that "nudge" in the right direction. It worked well!

Is there a way to extend any date to the first day of January in the next year? (example 13/Oct/08 to 1/Jan/09 or 3 Sep/09 to 1/Jan/10)

OK, I've tried something different that appears to be working so far on the test data I'm using. I've formatted the top row of the Date Field in the query to "DateField:Format$([tblDonations].[DateField],'mmmm yyyy') and in the Criteria I've called the prompt [Enter Full Month and Year:] and...

What I have in the report textbox is =Format([DonDate],"mmmm") The DonDate is the field in the query that hold the "between" criteria. I tried to leave out the square brackets from around the datefield but access puts them back in. The error I get is a circular reference. This is what...

It doesn't work in the text box on the report. On the query design I have the "between" statement in the date field. So, if that's where it is to go, how do I put it in place, and where without losing the Between query? I'm using access 2003 BTW.

I have a query that selects data for a month (any given month) between the first date of the month and the last day of that same month. The return I get is exactly what I require. Is there any way, on the report based on the query results, to display only the month that the query pertains to...

Thanks a million for all the input everyone! It's most appreciated. Both setting the Required property to YES and adding the code to the BEFORE UPDATE work. I really like the discussion - a lot of good points from a lot of experience! Thanks again!

I tried to run a search, but, I'm likely not entering the correct question - so I'm hoping someone can provide an answer or steer me in the right direction. I have a subform in which the user enters a date in the medium date format (using the input mask). Is there some way that I can make...

Hello All: I'm tracking driver accidents and trying to generate a report for safe driving awards. I have 2 tables I'm using for this. The first is the driver table which contains the key (employee number) driver names and the date they started work. The second is the driving record table...

The categories are "fixed" as are the identification numbers for each donor. There would not be an occasion for requiring any more categories than the ones we already have. The donors are issued a specific identifying number at the start of the year, and that number remains with the donor...

I have two linked tables that I'm drawing information from. The first table has donor information, including an identification number, the second table has 46 fields (different donatable categories) and a "donation date" field. All the donations have default amounts of $0.00 Many donors...

Thanks George! Sometimes a "kick start" is all that's required! I ptrefer to develop this db myself. There are lots on the market, however, none can quite compare tp personal preferences. Thanks again!~

Hi All: Either I'm having a brain freeze or I can't see for lookin'... I am creating a database for our church's financial secretary. Every year, contributors are provided with numbered offering envelopes. At the beginning of a new year, when the envelopes are issued for the year, often the...

Does the standard apply wherein Access 2003 can open and manipulate data created in 2000 but when it is saved it saves the data in Access 2003 format? Or are they all inter-workable such as 2000 and 1997?

Thanks pdx_man! That did the trick. Works well now!

The field label is "Casualties" and I did build the query in the design view. After I select "expression" in the totals row, where do I enter the expression?

I've created a query to count and display the number of "yes" check marks in a field. There happens to be 20 of those marks but in the results it displays "-20". Can anyone explain to me how to correct that? There is no default setting, neither yes nor no, in the field properties setting in...

That makes perfect sense. I may do some modifications. Thanks for the heads up! Maybe eventually I'll get the hang of this relational database after all. I'm used to working with the MS Works flat database but I see the far greater opportunities a relational database has to offer. Thanks...

Thanks a million! But... as you alluded to.. how could this have been set up better? I'm very new to Access and what I know is self-taught.

There are 50 fields - [Empl1] thru [Empl50]. Each day is a new record. So, what I'd like to be able to do is generate a report that can show the total hours worked for any given day. Then I'd like to be able to extrapolate that to show a total of hours worked in any given period of time -...