Search results

Hey. How do I format Date field in query grid to make field into "11/11/2007" if the data originally has time, or in form "11 Nov, 2007" ?

does anyone know what this code would be like in DAO ? [code] DoCmd.TransferText acExportDelim, "My_Transform", "Table", "C:\temp\xxx.csv" [\code]

THANKS !!!!!! This is fantastic !!!!! Exactly what I needed. I already utilized that. :D:D:D:D

Well, the situation is like this. I am creating CROSSTAB query from a table that needs to be exported in the same format every day. Sometimes it has data in 0-2 age, sometimes doesn't. Depending on that "0-2" column will, or will not exist. I'd like it to always exist. (perhaps somehow...

grim outlook... is possible in Access ?

Is there a way to specify in the query sql, if column XX exists in a table, pull it, if doesn't exist, create a blank column "XX" ?

Hey, I have it creating 4 queries to 4 tabs, thank a lot. Is there a way to include column headings ? Also, can it be sent to a template ?

Thanks Gary i put my query names; for some reason the first query is not creating, onle the second one :rolleyes: and Column headings are gone :confused:

Can this be done through a macro ? If not, what would be a simple way to do this ? thanks.

i found it; here it is # of Days Stale: DateDiff('d',[date],Date())-(DateDiff('ww',[Date],Date())*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between [date] and date())

I've had it before, but can't find it. basically something like this -- DateDiff("w", StartingDate, EndingDate) that also makes sure date is not in tblHolidays. anyone knows how to acomplish this ?

Thanks RuralGuy. in the meantime i found that access has Calendar8 built in. Do you know if its possible to have 12 of them on a single form, with Vacation Dates highlighed ?

Hey All I need to have a calendar in the Access form, where the user selects the dates, and first date is selected as date1 and second date as date2. Is this possible ? regards

Table is not archive. They cointain similar date, from 2 different sources Making table B's Trade Id (Indexed. no Duplicates) solved the problem. I realized it as soon as I poster the message. ;)

Thanks Bob ! Nz worked great.

Hey All how can I have a Label or TextBox countain sum of 2 values in Form ? Form is based on a table; I'd rather not change it to a query. I think I've done it before; but don't recall exactly how.

Hey All I have 2 tables - A and B I am assigning trade ID from A to B, where they have several common fields. Two conditions are needed. a) Only update records where B doesn't have trade ID yet. (done) b) Do not update records with a Trade ID , if such id is in a a Table B. not sure how to do...

Hey krc What you are showing will copy table/query. I am looking at exporting values from a list in a form

Hi everybody I am having a terrble problem exporting list's values to Excel. This how I am doing it Private Sub cmdFailedToExcel_Click() Dim tSQL As String Dim sql As String Dim TradeDate Dim fld As DAO.Field Dim xl As Excel.Application Dim wb As Excel.Workbook Dim rng As Excel.Range Set...