Search results

Thanks for your time. I'll try that.

SQL is not what I'm used to work with if that is what you ask. I do understand: Select Date From 1stQry union Select Date From 2ndQry So to use 4 queries I must use the code you said, but I did not understand about "create yet another subquery ..." select A.date from (select date from...

I am trying to group 4 queries that are made from 4 tables. Each table has date field with various dates. I try to build union query that would ash me date interval and show all dates as first column, then I wan't to add extra columns from those 4 queries so they woul be displayed as my first...

I would also like to filter by date interval. Is this ok? select date from 1stqry union select date from 2stqry union select date from 3stqry union select date from 4stqry WHERE [date] = Between [enter start date] And [enter end date]

I use Access 2007 and my databse is old 2003 format mdb. 1. I made a backup copy of my database file. 2. I left Name AutoCorrect ON 3. I started renaming my reports by adding rpt_ 4. Tested if they work - They DO :) 5. Started to rename tables adding tbl_ 6. Tested if they work by opening...

Thanks everyone, I'll try the program and post back.

But in practice access tracks all objects by itself, only formulas can have a problem no? So reports can be renamed without any problems because they are the last objects in a chain. Tables are the first and can have some problems as queries too :( I hoped there would be a guide or...

When you are working with the seven different object types that make up Microsoft Access, each of the objects has its own prefixes. A list of those prefix names you should be using for the Access Object Types are shown below - db - Database tbl - Tables qry - Queries frm - Forms rpt - Reports...

Thanks, it works :) Would it work with 4 queries? I just realised that I would need to all 2 more queries from separate tables that have field date also. Select Date From 1stQry,2ndQry union Select Date From 3ndQry,4ndQry Then I would create normal qurie like you said and link all 4...

I have 2 queries (one for debit records other for credit records)that I need to put into 1 so I can build a report. 1st query has these columns: Date KIO Order number Sum total 2nd query has these columns: Date KPO Order number Sum total I need to put them into one query that would work...

The Case table that I call Tipas has autonumber field and Unit field --------------------------------------- 1 Unit Name 2 Unit Name 3 Unit Name 4 Unit Name

I use the code you gave me: Public Function Decode(InCode As Integer, InField As Variant) As String '-- Used in a query like: '-- Kiekis2:=Decode([Tipas],[Kiekis]) Select Case InCode Case 1, 3, 4, 5 Decode = FormatNumber(InField, 0) Case Else Decode = FormatNumber(InField, 3)...

Since nobody else posted any ideas I posted my question on http://www.utteraccess.com/forums/showflat.php?Cat=&Board=82&Number=1601446&Zf=&Zw=&Zg=0&Zl=a&Main=1601446&Search=true&where=&Zu=136576&Zd=l&Zn=&Zt=c&Zs=&Zy=#Post1601446&Zp= Got some replies that I should not use FormatNumber in...

Thanks for your help. I could use IIF up to 7 levels deep right: IIf (1=[pagrindinis]![Tipas]; FormatNumber([pagrindinis]![Kiekis];0);IIf (2=[pagrindinis]![Tipas]; FormatNumber([pagrindinis]![Kiekis];3);IIf (3=[pagrindinis]![Tipas]; FormatNumber([pagrindinis]![Kiekis];0);IIf...

found some sample code with function switch anyone could give a hand if possible to make it work?

Tried it got same error: The expression you entered contains invalid syntax I think that access don't know what to do with field Tipas as it is being pulled by lookup from another table. IIf function worked OK but now I need more options to choose from that is why I'm looking how to get a...

I must admit I am using them :rolleyes:

I'm using access 2007 but my database is in access 2000 *.mdb file format. I have a table named: "tipas" with fields: ID autonumber Tipas Text Then on table named: "pagrindinis" I have lookup field "Tipas", data type Number to get data form table "Tipas". I then designed a query using...

I just added the code Kiekis3:=Decode([Tipas],[Kiekis]) in my query in design view. I changed filed name from Kiekis2 to Kiekis3 because I still left my old field named Kiekis2 in the query and I can't have two fields have the same name. Still I get: The expression you entered contains invalid...

I tried your code, created module and pasted the code. Then In my query I added a field Kiekis3:=Decode([Tipas],[Kiekis]) Then I got error: The expression you entered contains invalid syntax If I changed to Kiekis3:=Decode("[Tipas],[Kiekis]") I get error: wrong number of arguments used with...