Search results for query: *

error solved. There was a glitch with the key

Hi, I created a form for use with data entry. It is in Tabular format. Is it possible to create the form in tabular mode that allows for data entry? The problem I am having now is that when a user is trying to enter data and tab from one field to the next, the cursor moves from the record that...

My apologies. I have a database that captures data in a field named "TripTime". This field is in Short time format and has hours and minutes stored in it. It represents the time it takes to complete a trip. We now would like this field to be doubled...as for a round trip. Multiplying this value...

Hi, I have a db with the requirement of having to multiply time...can this be done via an Access query without too much hassle?

:) Stuck due to specialised software that didn't tab over to the next tab... Thanks...what you said made me dig further...and voila!

Hi again... This should be an easy one. How do you execute a query from inside another query using the GUI of Design View?

That was exactly what I needed, thank you so much.

Hello All, I have a question about breaking a number out of a text string and then running a sum of that number. I know how to break out the numeric data, but I'm uncertain how to run a calc on it as it is still in a datatype of text. Can you help?

I FOUND IT!!! thread703-1178919 Thank you all for your time!

YES! :) Can it be done??

I want to count individual volunteers and have it as a total at the footer of a report. When I try to count the ID it gives me every ID that appears. Thank you again...

How would I implement that into this:? SELECT Volunteers.FirstName, Volunteers.LastName, [LastName] & " " & [FirstName] AS FullName, Volunteers.Region, VolunteerTransactions.Event, VolunteerTransactions.Hours, VolunteerTransactions.Date, VolunteerTransactions.ID FROM Volunteers INNER JOIN...

Nope..

Invalid syntax :(

Hello, I am trying to create a report which lists volunteers and their transactions across a speicified date range. My goal is to provide a sum of all volunteers during that timeframe. I have tried Count(ID) but it counts every transaction. I need a way to count DISTINCT folks...evidently...

Thanks a million Pete! You know I looked and found a module on Microsoft's website that had a much more code than this and I still couldn't get it to work??? You did a magnificent job! Thank you...and best yet I understand why it does what it does!! (I can only give you one star...but I wish I...

Thanks Pete! I wish I could give you more than 1 star! Do you by chance know how I could calculate it to show also the days...so that at the end of the report it will show the days, hours and minutes..?? Oh thank so much...

Hello, I am wondering how to allow a summary of time on a report. I have a field in my query which calculates the minutes, but I can't seem to get the formatting or syntax right on the report. What I would like is for the elapsed minutes to be displayed in the report footer in days, hours and...

Thank you both so very much. Using both examples I have successfully accomplished what I set out to do!!

Hi! Thanks for responding. The examples are in different rows repectively. The :31 and so forth would represent 31 minutes but when it was imported into Access from Excel it turned it to 12:31; if the data 1:02 it was to represent 1 hour and 2 minutes...again, the coversion turned it to 1:02AM....