I have a form that displays an outing for members to sign up. There is a subform where I display the members of the organization (via a combo box), using a...

I have a combo box with hospital names in it. I am wanting to select a hospital from the combo box and have the the address text box automatically fill in...

I need some help. I have 5 check boxes. There is one for each country of Canada UK USA France Germany And i want the users to be able to tick which countries...

For some reason First and Last are giving the wrong data in a Totals query. I assume that somehow the data is not ordered correctly in the main table, but it...

Hi, I'm using Allen Browne's code from Has the Rcd been Printed and all of that is working great. I'm now trying to implement the Taking it Further - Track...

I am using the following query to create running balance at every change of Invoice Number but no luck, here Invoice Number is a text field SELECT...

I am in the beginning stages of setting up a call database that tracks calls made by sales people. The table includes separate fields for date and time. A...

I need help with this , it will not run, am i missing something. Private Sub Worksheet_Activate() Call Sheet5.getvalues Call Sheet5.SortRange1 End...

I get incorrect results when I do the following query: Field a = "X" Field b = Not "Y or Not "Z" Field c = Between and

Firstly, let me apologize for making this beautiful cross-post. I know it bad etiquette, but in this instance I'm hoping no one will truly mind (after all...

Hi everyone, This should be simple. I'm trying to pull one random record from each group within a table. The groups are "Units" - geographic areas, and I...

I need a way to loop through an invoice and figure out the number of boxes being used per order. We have the same product that can go into multiple size...

Hello there, i have a form with a query that calculates the average processing time for a event and it works fine when there's been more than one entry. I...

AMOUNT: CStr(!*!) How do I convert $45.50 to "45.50" ...? No matter what I do I keep dropping the zero to "45.5" thanks!

Free Live Voice and Video Chat!Connect with Over 4 Million Members download now on http://www.tkqlhce.com/click-3714215-10516597

I have created a union query and now want to create a field alias to specify which records come from which query. The union query works as such: SELECT * FROM...

I have on my customer master, a field for credit limit. The user can input the credit limit for that particular customer. When the user then goes in to the...

My table has three columns, AcctNum, TransDate, SeqNum I need a query that only displays the last "SeqNum" when an "AcctNum" had multiple entries on the same...

Hello I have two Tables. tblMain(MainID) tblSec(FamID, Group, MainID) MainID has same attribute in both tables tblMain has the correct records. How can I...

Hello, I was hoping someone could assist with the following expression in access that combines the Left function and Len function: I have column called ID,...