Recent content by kcyankees125

I have 9 fields on a Form that act as inputs to a Query. I then display the results of this Query in a Report. Is there any way I can display the 9 input fields as part of the Report Header?

Actually, Access is giving me an error when I try to use that... an undefined function in expression error. Any idea why?

One last question, is there a way to reference multiple columns from that same combo box? I'd like one criteria to be based on the [DESTINATION] column and another criteria in the same query to be based on the [DESTINATION_TIME] column.

How would I do it if I left the Combo Box Not concatenated?

I currently have a combo box called [DI_CONNECTION] set up on a form [Startup] that has a row source of: [ORIGIN] & " - " & [ORIGIN_TIME] & ", " & [DESTINATION] & " - " & [DESTINATION_TIME] I would like to do a query that shows all records that have the same [DESTINATION] how do I reference...

I have an update query that I would like to do. Is it possible for me to have both the update "D" part and update "I" part in one query, or do I have to separate them. (Currently Access tells me that it finds characters after the end of the SQL statement UPDATE WorldAreaCodes2 SET...

I'm new to SQL... could you give me some guidance on which functions?

I have a table called say [DATA]. Among many more, there are 2 fields called [ORIGIN] and [DESTINATION] each with a 4 letter alphabet code that represents the location (e.g. ABCD or JEVK). I have another table called [CONVERSION] that has 2 fields: [CODE] with all of the 4 letter alphabet...

I have a table [DATA] that has a Field named [CODE] with each record having a value from 0-9. I would like a query that creates a new field called [TYPE] that shows a D if the [CODE] value is 0 and shows an I for everything else. How can I do I do this?

Great Thanks! Since I'm fairly new to using modules and VBA and what not... How do I call UTCToLocal() in a query on a specific field named [DEPT_TIME]? I'd like to name the new field: DEPT_TIME_LOCAL.

Fairly new to Access... and need help. I have a data source that gives me time in the UTC format with time zone adjustment given: "0000+0000". This is in the field of a table called [DEPT_TIME]. How do I convert this to local time? For example "0230-0600" should give me something along the...