Search results

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)

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...

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...

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...

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?

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...

I have a table that contains 50 fields. Each field represents an employee. The employees hours are recorded each day that they work. I need to generate a report that, at the end of the month, will generate the total number of hours, worked by all employees. I have a query set up using the...

I created a fairly large database with numerous tables. I've used up the full default size of the Form format for inputting the data. I am very new to Access and really like it! But I have not taken any formal training and have not done a lot of coding. Is there some way that the scroll...