Search results

I don't actually know if this should go in forms or queries or reports. I have a query by form that I am creating. One of the criteria I would like to include is whether or not the consumer is still active. I have this in the original data using a checkbox. I would like to have it that if in...

I'm creating a sum query to base my report off of and I am allowing the user to enter the dates it would like the query to run between using the following syntax in the criteria: Between [Enter Start Date:] and [Enter End Date:]. I would like the user to be able to leave the field blank...

I have a report that sums up the hours my volunteers have volunteered (per person) and gives me this, their ID No. and a couple other things (name, etc.). Everything looks great in the query I have, but the moment I try to create a report, all of the numbers go weird. The autonumbers don't fit...

Okay, I apologize because I know this question is probably overworked and I searched the forums for something along these lines, but I apparently haven't been able to find the right search criteria to find the posts on it. I am trying to have a parameter prompt in a query where the user enters...

I am working on a database which due to its complexity (and/or my lack of knowledge of access) has four queries based on two seperate tables. The first table is full of customer data and the second is transaction data linked to the customer data by the customer id no. The queries are as...

I am creating a database to manage the volunteers in my company have worked. I have two databases, one is their volunteer information. The other database is an "HoursDatabase" where I can input the volunteer's ID number, the date, start time, and end time of each time a volunteer has been...

I'm uncertain how to continue, or if it is even possible. I know the forums are generally for more specific questions, but I'm really hoping someone can point me in the right direction here. I've tried searching and help and a couple books, but I still don't know how to proceed. I have two...

Okay, I don't know if there's a better way to do this. If so please explain how, but otherwise, I need to fix my ?coding? I think? I'm creating this database to track my volunteers' information and to track their hours. I have this set up as two seperate, but intertwined databases. One database...

I'm not 100% certain this is a "forms" question; it may simply be a general question. How do I get access to automatically pull up a form when I open the access file? I have volunteers entering data into the form and not all of them are very...computer savvy, so I was trying to reduce the...

I am admittedly VERY inexperienced with any sort of coding and with the command buttons themselves and am trying to do something that (from my perspective) is somewhat complicated, but as I am not the only person dealing with my database and most of the people entering data have never even...

I'm attempting a rather complex mail merge and am using Access to organize the information. However, in the letter which I am sending, there are dates that need to be included. I would like to use the long date format, but whilst I can get it to appear that way in Access, I am unable to get it...

I am somewhat experienced in Excel, but not as much in Access. I understand that they are very different, but in Excel there is a formula called fixed which can take a calculated sum into another cell and translate it into a text format with only two decimal places. I use this formula for a...