Recent content by Focusfocs

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