Search results for query: *

I have a form with a datasheet subform. I need the datasheet to automatically expand to the number of records in it. If this can't be done, what options do I have?

Thank you so much. Your tip worked like a charm and I am more than grateful.

I have a report containing a combo box for record status. My report is grouped by record status and I have group totals for each. Now I need to group various combinations of those values and count the number of records meeting only those criteria. For example: status = "active","inactive","on...

Good morning: Thank you for your response. I'm sorry, but I'm still confused. I identified the information below in the Criteria of my query but it tells me something about a 'string being less than 255 characters.' I then tried the same syntax in a text box on my form and get the Name...

I have a combo box listing several choices for the [status] of a record. I need a summary form showing how many records have "x" status; how many have "y" status; how many "x" or "y" status, along with various other combinations and then the total count of records. These values are derived from...

[date] does refer to the date field in the table which is contained in both the ToDo and the Event. I appreciate your help and expertise. It's been quite some time since I've had to use this part of my brain; so it's a little rusty. I had forgotten how much I love this stuff. Donna

The CVDate and Time is used to convert the Clarion dates to Gregorian dates.

Tasks SQL - the previous post was the Event SQL SELECT CVDate([date]-36161) AS Dates, TODO.STAFF, TODO.[DESC$], TODO.MEMO, TODO.MAT_REF, TODO.STATUS, TODO.CCODE, TODO.ASTAFF, TODO.MAT_ID, TODO.SYSID, TODO.DATE FROM MATTER INNER JOIN TODO ON MATTER.SYSID = TODO.MAT_ID WHERE (((TODO.DATE)=74604)...

SELECT CVDate([date]-36161) AS Dates, [times] AS [Begin Time], EVENT.STAFF, EVENT.[DESC$], EVENT.MEMO, [time]/8640000 AS Times, MATTER.MAT_REF, EVENT.STATUS, EVENT.CCODE, EVENT.ASTAFF, EVENT.MAT_ID, EVENT.SYSID, EVENT.DATE FROM MATTER INNER JOIN EVENT ON MATTER.SYSID = EVENT.MAT_ID WHERE...

I have several tables including a Matter table, Contact table, Tasks table and Event table. Both the Event and Tasks tables contain the date, description, location, staff responsible along with the matter and matter id the task or event is related to. The Event table has a time field; the Task...

I have an Access database pulling info from a canned database via ODBC in which there is a Tasks table and an Event table (among others). The Tasks table contains things to do for any given day and are date dependent; the Events table contains appointments and the like which are both date and...