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: jbelf
  • Order by date
  1. jbelf

    Link a Report to a single form record.

    Hi, Anyone know how I could link a report to a single record? For example, when scrolling through records on a form, I'd like to launch a report that contains information from that single record. I created my report, but it currently is linked to the table, and as a result, brings up all...
  2. jbelf

    Required fields in forms

    Hi, is there a way to make a form field required? I am aware I can make it required at the table level, but I am creating several forms for this database, some forms need to have required fields, but other forms do not - the all write to the same table. I found the validation bit - but am...
  3. jbelf

    Grouping a report by month

    Hi - first, thanks to all for the consistent great advice!. Now, the big Q... I'm trying to create a report that captures how many projects were opened, closed and canceled in a given month, grouped by each month in the year. Fields I have include start date, end date and status. I can...
  4. jbelf

    Sorting Formatted Months?

    Hi, I have a query and some reports that group by month, which is a date field formated as follows: Format$([xxxx],"mmmm yyyy") Only problem is Access is sorting this group alphabetically, not by month. So April is first, then August, December, February, etc. Not Jan, Feb...
  5. jbelf

    Translating a number date to a text month?

    Hi, I have a date field, but I'd like to display the text 'month' for some graphing and reports. I've converted the date (6/2/03) to the number month (6)using DatePart("m",[end date]), however this only converts it to a numbered month (6). How can I get this to display 'June'? Any...
  6. jbelf

    Excluding lowest numbers on a report

    That's it - thanks!
  7. jbelf

    Excluding lowest numbers on a report

    Thanks for the resonse. How would I translate that to simply count only the top 5? My current line states this: =Count([end date]), which counts all records in the query where an end date is filled out. any thoughts? many thanks!
  8. jbelf

    Excluding lowest numbers on a report

    Hi, I'm trying to do several reports with graphs that count the amounts of records, grouped by type. For example, if there are 15 'types', I want to count the sales for the top 5 types, so I can create a meaningful graph (basically exclude the outliers). I've successfully found the 'count'...
  9. jbelf

    Access 2000 backwards compatible?

    Hi, I'll need to develop a database w/access 2000 (at home), but it's for Access '97 users. Will there be a backwards compatability issue? Thanks in advance!
  10. jbelf

    Querying 30 days back in Access

    Whoo hoo! two different forums, 6 replies and joebrens was the only one that worked for me. Thanks!
  11. jbelf

    Querying 30 days back in Access

    Hi, Trying to create a query from a 'start date' field, which brings records back listed 30 days back from the current date. I thought the syntax was 'now-30', but it apparently is not. Date()-30 brings back records that are exactly 30 days old, but I need all records in the past 30 days...
  12. jbelf

    Microsoft Access Limits

    hi - quick question. I have a database consisting of some forms, queries and reports that sits on top of 1 table (about 50 fields). I need over 10 people to be able to use this database concurrently. What are the limitations? would it be improved if i split it up to use more tables? Any...

Part and Inventory Search

Back
Top