Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Focusfocs
  • Order by date
  1. Focusfocs

    Data Entry Tabular form trouble

    error solved. There was a glitch with the key
  2. Focusfocs

    Data Entry Tabular form trouble

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

    Multiplying time in Access?

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

    Multiplying time in Access?

    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?
  5. Focusfocs

    Can you execute a query from witin a query...

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

    Can you execute a query from witin a query...

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

    How do I create a numeric field from a text field....??

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

    How do I create a numeric field from a text field....??

    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?
  9. Focusfocs

    Select Distinct? Counts??? Help please

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

    Select Distinct? Counts??? Help please

    YES! :) Can it be done??
  11. Focusfocs

    Select Distinct? Counts??? Help please

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

    Select Distinct? Counts??? Help please

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

    Select Distinct? Counts??? Help please

    Nope..
  14. Focusfocs

    Select Distinct? Counts??? Help please

    Invalid syntax :(
  15. Focusfocs

    Select Distinct? Counts??? Help please

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

    Summing Minutes on Report

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

    Summing Minutes on Report

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

    Summing Minutes on Report

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

    Calculating Time in Access. How to derive minutes?

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

    Calculating Time in Access. How to derive minutes?

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

Part and Inventory Search

Back
Top