Search results for query: *

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

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

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

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

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

That's it - thanks!

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!

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

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!

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

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

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