Search results

SELECT DISTINCTROW Format$([amos_WorkOrder].[DueDate],'mmmm yyyy') AS [DueDate By Month], Count(amos_WorkOrder.WONo) AS [OverDue WO] FROM amos_WorkOrder GROUP BY Format$([amos_WorkOrder].[DueDate],'mmmm yyyy'), amos_WorkOrder.WOStatus HAVING (((Format$(amos_WorkOrder.DueDate,'mmmm yyyy')) Is Not...

The criteria is a value on another field, i.e 1-6

Hi, Sorry of this is a daft question but I’m not a regular user of Access. I have a requirement to sum a Value on a report twice, based on two different criteria and I’m not sure how to go about it. Have tried creating two queries but Access won't let me use both of them on the same report...

That worked, but next problem Cheers, That worked, but now it crashes at following line rst.Fields(Mid(myString, 2, InStr(1, myString, "_") - 2)) = Mid(myString, InStr(1, myString, "_") + 1) Will work on it, may ask for help later Thanks :)

Dim rst As DAO.Recordset Namliam, Thanks for your input.... Having the following error "User defined Type not Defined" As you can guess i'm not a VB programmer. Can modify code and fairly useful at using Access. Any advise appreciated.... T

Thanks That would be so useful. Appreciate if you could, i can then modify for other tables etc... Thanks :D

*0_ is always the begining of the initial data set. C = Component Table However, if there is no data contained in a field, then the representing column ID is not exported... (reduces file size).

Hi, I have the following Text file that can be extracted from our legacy system (see example below..) but it is extracted as a list. Is it possible to import this in such a way so that it is in a standard table foramt (accross)? Thanks in advance T C0_1000000ð860001 C1_*** M/T "SHIP" ***...

Hello again.... I'm trying to export data to excel and at the same time restrict the field sizes to match my table info. Is there an easy way to accomplish this without using code? Example:- My Query is exporting the following Fields CompTypeNo, Text, 30 CompName, Text, 40 LastReported...

Unique record identifier Pat, Thanks for you r help with this matter, i used the ALTER TABLE routine to solf my problem. Thanks for your help, it's appreciated Cheers Tony

Hi, I use access as a tool to manipulate data and then update our master database (Sybase). When selecting tables in the first instance you can select the "unique record identifier" and Access will allow you to update the specific data happily. If i send this database to a collegue in a...

Sorted ! When linking tables (seems to be Sybase specific) you must define the primary key for each linked table that you intend to update using Access. I tried this and it worked, Thanks for your help FoFa and Pat ! :cool:

Pat, Thanks for that, the unique key is CompJobID but still get the same error. Can you use this type of query in Access to update Sybase, one of our 'Technical bods' doesn't think you can? i.e Updating from a table external to Sybase. MOFE_LastDone_Engine is an Access table, AMOS_CompJob is...

Same error FoFa, Thanks for your response, i have tried modifying the code as suggested but get the same error. Any other suggestions?

Hi, Firstly i'm not an expert, so apologies if this is a dum question! I am linking Access 97 to Sybase via ODBC. Get the following message 'Access operation must use an updateable query'. I get round it by creating a new table in sybase and then running my query within sybase. Code...

ritchieroo, Thanks for the tip. I will try it in a SQL statement. As you can guess i'm not a programmer at all...... I was trying to create a funtion that I can re-use many times within the same access query, especially when creating record sets. I'm more familiar with SQL so i'll stick to...

I have this code:- Function ChangeDate(adate As String) As String Dim t As Integer Dim num As String Dim num2 As String Dim zyear As String Dim yyear As String Set dbcurrent = currentdb() num2 = Right(adate, 4) 'This is assigning the last 4 digits in the number to...

Cheers, It does exactly what i'm after, with some minor modifications in Excel. It's saved me hours of work...... Have 160 tables, some having 50 or more columns..... Thanks again, T :p

Hi, I'm currently working on a project that includes migration from legacy systems, and as part of this will be conducting some data mapping. To create the mapping documents i would like to export the table properties, from Access to Excel. Fields required are, TableName, FieldName, DataType...