I need to display date ranges for missing data in a query in the following manner:
1/1/08-1/15/08, 126/08, 1/28/08-2/5/08, etc.
as opposed to
1/1/08
1/2/08
1/3/08
etc.
is there a way to do that in access?
jackiefm
Last Activity: Mar 31 '08, 03:33 PM
Joined: Oct 3 '07
Location:
-
Multi Colmn Reporting within a group
I have an access report with data that displays by vertically by group in multiple columns. Is there any way to dsplay the columns within the group instead of vertifcally by group? Example:
Current display
John Doe
1/1/08
1/2/08
1/3/08
1/4/08
Instead:
John Doe
1/1/08 1/3/08
1/2/08 1/4/08 -
I have created the queries and reports as required but the query keeps returning that Access does not recognize the criteria as a valid field name or expression. -
Limit records in a query by group
I have a crosstab query that I need the returned records to be limited to the top 10 for each group. How can I accomplish this? My sql
...Code:TRANSFORM Count(Violation.Driver) AS CountOfDriver SELECT Driver.RegionName, Driver.Code FROM (Driver INNER JOIN Violation ON Driver.Code = Violation.Driver) INNER JOIN Terminal ON Driver.TerminalName = Terminal.Address1 WHERE (((Violation.Description)="11 hour" Or (Violation.Description)="14
-
We are all defaulted to the same printer. We are all in the same department.Leave a comment:
-
All the data is refreshed before the report is printed. This seems to be pc specific. It is not an issue with the database itself. Everyone uses a copy of the same front end however it works for some and not others. It is either something that needs to be installed on the pc or for Access...Even the IT guy can't figure this one out. There is not user security set up on this database either.Leave a comment:
-
I actually designed a report and created a button that prints the report based on the open record. Some computers will print the multiple pages and most will not. I cannot seem to find anything common that would prevent one pc from printing all of the subform records and others not....Leave a comment:
-
Multi-page access report won't print
I have an Access database front end/backend situation. The users create a record in the main form and add subrecords in the subform. When complete, they print a report that is very often multi-page but the report will only print the the subform records which will fit on the first page for some users. Can anyone tell me why that would be? -
Unfortunately I followed all "rules" to prevent this issue but still seem to be unable to resolve it. Below is my query. There is not formatting in query or table, no grouping on TerminalName, any suggestions?
SELECT [Assigned Terminals Export].PartyID, [Assigned Terminals Export].PartyName, Last(Concat([PartyName],[TerminalName])) AS Terminals
FROM [Assigned Terminals Export]
GROUP BY [Assigned Terminals Export].PartyID,...Leave a comment:
-
I believe it is using the default text format which is limited to the 255 char. It is a new field created through the query. Is there a way to change it in the sql? The field is:
Last(Concat([PartyName],[TerminalName])) AS Terminals
This field was created in the query. I have changed both TerminalName and PartyName to Memo fields with no success.Leave a comment:
-
I do however have one other problem. The field size is limited to 255 char. Can that be changed. Each terminal is 3 characters long, with the space and comma I am limited to 51 terminals can be combined to this field. Some users have access to over 700 terminals.Leave a comment:
-
I can only apologize for the missing the most obvious. I neglected to remove the underscore in the module after I pasted it. Once I removed the underscore, complied and saved it worked like a charm.
Thank you, Thank youLeave a comment:
-
Unfortunately that did not help. Is there a reference I need to add maybe? I currently have:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 LibraryLeave a comment:
-
I have added it as a module but it still gives me the same error. Is there something else I am supposed to do?Leave a comment:
-
Combining Multiple Rows of one Field into One Result
I realize the thread I am responding to was posted in January but I am basically having the same issue. I am not familiar with VBA but use Access daily. I have written simple scripts but nothing to write home about. I followed the previous thread and my situation is very similar.
I have an application with users. These users have access to multiple terminals. I am trying to combine the TerminalName field with all terminals the user...
No activity results to display
Leave a comment: