Search results

Hello I have a basic question, I have a table and want to compare dates .if date 1> date 2 , then pop a message . any Idea how can i do it ? with query or with VBA ?? Thank you

hello, I have a quay to group by 3 field and do sum in other fields . I want to have two other fields but not to be group by I want to be a part of table but i face the below error. how can do that ? any idea ? I appreciate for your help

I really I really appreciate that .my problem with this code solved .Thank you

Thank you It does not work for me :( what is simplecsv ?

Expr1: ConcatRelated("CrewName","QryCrewStudy","QryCrewStudy.Rank = """ & [Rank]![Rank] & """ AND QryCrewStudy.On_Date = #" & Format([Dated],"mm/dd/yyyy") & "#","CrewNameRev") Could you express this code ? which one is the field were grouped by , what is table or query name and which field was...

I added two tables to see what i expect to be the result . Thank you

Why it doesn't work for me ? I want to do group by Aircraft Type,Aircraft Manufacturer Serial Number,and Event Type fields then concatenate Aircraft Event Text (Corrective Action) field. Can you help how to do that ? Thank you

ConcatRelated() function doesn't work in query.it is unknown

Hello I need help in concatenating a string field in rows : I want to do group by AC Model and Ac Serial,then concatenate all AC event text strings for it together. Can you provide me a solution ? Thank you

Thank you my problem solved by this . IIf(Month([MONTH])=1 Or Month([MONTH])=3 Or Month([MONTH])=5 Or Month([MONTH])=7 Or Month([MONTH])=8 Or Month([MONTH])=10 Or Month([MONTH])=12 And ([PLANNED] Is Not Null Or [Scheduled] Is Not Null Or [Unscheduled] Is Not...

Hello I need a help in sum of some fields I I want to sum (p and s and un fileds) id the month is 8 and add in O field? when i write id the query ,i have a lot of errors Operation_SUM : IIf ( Month([MONTH)]) ="8",([PLANNED]+[Scheduled]+[Unscheduled]),0) Could someone help to do this query...

Thanks but it is not a table,it is a query that collects data from other queries.

Hello I have a query that shows the correct details. it should show 12-month data before the exact END DATE from exiting data . for a specific case,I have just 2 2 month records to show. How can I add a condition if the other months are not on the list put their value 1 or 100%. this query ...

I changed it and the result:

from database 1 It should open database2 and run macro "main" on it. it doesn't open database2.

Hello I have two databases,1and 2,I want to run a macro from database 2 in database 1 : I have the below code, but not work and no error .can you hint where is the issue? Public Function run_main() Call CallMacro() End Function Public Sub CallMacro() ' Dim strDbName, strMacro Dim...

I found the issue in this line DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "DATA", varFile, True, "Report Details!" I changed the excel type to DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "DATA1", varFile, True, "Report Details!" and the import...

I found the issue in this line DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "DATA", varFile, True, "Report Details!" I changed the excel type to DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "DATA1", varFile, True, "Report Details!" and the import...

yes i changed it to long text

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "DATA", varFile, True, "Report Details!" DATA is my table name