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 bkrike 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: BeffyMar
  • Content: Threads
  • Order by date
  1. BeffyMar

    Query grouped and summed by week

    I want to create a query that sums all the fields by week so that I can chart the values.&nbsp;&nbsp;I cant seem to accomplish this task and my time-series graph never gives me what I want.&nbsp;&nbsp;Any suggestions??<br><br>THanks in advance<br>Mary Beth
  2. BeffyMar

    Chart based on query

    I have several charts that are based on a query. The criteria for the date field is<br><br>Between Now() and Now()-[Enter Number of Days]<br><br>This works well... but I want to get the number of days that they entered and put that on the heading of the chart<br><br>ex. All Equipment in the Past...
  3. BeffyMar

    SubReport Error

    I have a main report that is produced according to an embedded query.&nbsp;&nbsp;The person must enter in a Fiscal year and the dates are pulled from a fiscal year table and used to compare date fields in another query in the main report.<br><br>The subform uses the same first query that gets...
  4. BeffyMar

    Counting Records

    I have created a field that counts the records in a report but what I really want to do is count records with this twist.&nbsp;&nbsp;I want a count of all records that contain a negative in lapstime field and I want a count of all records that contain a positive in lapstime field.&nbsp;&nbsp;How...
  5. BeffyMar

    Update table through combobox

    I have a combo box on a form that lists names from a table.&nbsp;&nbsp;If the user adds a name that is not on the list then I want that name to be added to the table automatically.&nbsp;&nbsp;I cant seem to code the onNotInList properly.&nbsp;&nbsp;Any suggestions would be greatly...
  6. BeffyMar

    capturing record ID

    I know that this is probably a stupid question but here it goes... I want to capture the actual record number and contain it in a field... I tried the autonumber method but this isnt accurate because if a record is deleted then it throws the numbers off...I am desperate here... I think that I am...
  7. BeffyMar

    Calculating the Difference between times (hours)

    I have 2 fields MachineDown and MachineBackUp..<br>I want to set up a field that calculates the Hours from when the Machine goes down until the Machine comes back up.&nbsp;&nbsp;This may be a simple question, but I am just getting started in this area...<br><br>Any help will be greatly...

Part and Inventory Search

Back
Top