Search results

Thanks again ! Excellent !!

Thank you so much ! I thought the a.po_num = b.po_num was same as the inner join clause. I'll try that and see. :-)

It was like : ( not using the exact field names) select a.f1,a.f2.a.f3,b.f1,b.f2.b.f3,b.f4,b.f5 from a,b where a.po_num = b.po_num and datepart("m",[b.po_date] = [Enter Month Name ?])

I know this is simple, but I'm lost ! I have two tables A and B. Both have a common field PO_NUM. My query is supposed to get 3 fields from table A and 5 fields from table B. Condition is : Only those records that have a matching PO_NUM in both tables plus one field in table B must match user...

Hi All. Thanks for the replies. Will try and see. :)

Hi All. I have an excel file that needs to be imported into access. I get error when importing as one column is general type in excel, but stores mostly date values ( in dd-mmm-yyyy format.) Some of the records in that column in excel have text values like "till delivery date", "upto...

Thanks Pat. I'll try that and see.

Hi all. I have a query that appends 5 tables with 2 columns of same name. The query runs fine. But how do I move it into a new table with the select into option ? I get an error that it does not work with an action query ? Please help. my query : select order_id, part_num from a, union...

Thank you all very much. Appreciate your efforts. However, I feel I did not ask my question clearly. I'll rephrase my question and get back soon.

Hi all. I have a form based on a table with about 15 fields. Based on user input, I need to keep adding records. It could be say 5, 10 or 20 records in a grid like display on the form. Out of the 15 fields, some 8 need to be in the grid like interface as they may be repeating values. The rest...

Thanks Minty. It worked ! Had to use text1.value instead of text1.text due to control ref. issue.

Hi. I have a table with a long data type field called slno (serial number). Examples : 3345, 912768, 523409 etc. I have a form on which the user enters a serial no into a text box and clicks on a button to search. The form then shows only that record below. I want to use the filter property...

Hi. I have an unbound text box on a form that searches a word in a table and populates a combo box on a form with records related to that word. But, now I need to search with multiple words for the same. What I mean is, the table has data in the form of LT or L&T or Larsen & Toubro etc...

Thank you very much

Thanks. But is that the only way. No other built in function of formala in access sql ?

Hi All. I have a peculiar requirement. There is a materials table that has multiple names for the same material id. (due to some need) I have a query (group by) on materials table that runs fine and the result is as follows : MatID, MatName M123 Valves M123 Valves X M123 Valves Y Now, i...

Thanks Paul. But will Access really slow down ?

Hi. Can I use SQL server express (the free DB) as backend and Ms-Access 2007 as the front end for an application ? The reason is that; the the application I designed is working fine - split over a network with as Access front end and backend with few hundred records. But I guess, due to a...

Thx MarK. I'll try the code and see. :-)

Thanks for the reply. It is the way Indian currency is represented. 5,55,55,555.00 is counted (from left) as 5 Crores, 55 Lakhs, 55 Thousands and Five Hundred and Fifty Five. My regional settings is set to India on Win XP. However, I still get display as 55,555,555.00 with commas at the...