Please Look at this query
  Home FAQ Contact Sign in
Search only in:
alt.jobs.offered
 
 Advanced search
MATCHING GROUPS



more...
Group Profile...
POPULAR GROUPS

more...
found 14201 articles for 0.332 sec
RE: Please help with Update Query     

Author: rich
Date: Sep 22, 2007 20:30

Hello Karl, Thanks for the reply. I however need an update query. I need to update 2 fields in the dest. table. For that, do I need to run 2 update queries, 1 for each column? What I need is: Update tblDestination Set ...> I need help with the syntax of an update query. Source and Dest. tables look like this: tblDestination IDX EmplNum ...
Show full article (1.28Kb) · Show article thread
RE: Please help with Update Query     

Author: KARL DEWEY
Date: Sep 21, 2007 21:50

...-- KARL DEWEY Build a little - Test a little "rich" wrote: Hello Everyone, I need help with the syntax of an update query. Source and Dest. tables look like this: tblDestination IDX EmplNum ExpirationDate StartDate ARFDate other columns tblSource EmplNum StartDate ARFDate ...
Show full article (0.77Kb) · Show article thread
Please help with Update Query     

Author: rich
Date: Sep 21, 2007 21:28

Hello Everyone, I need help with the syntax of an update query. Source and Dest. tables look like this: tblDestination IDX EmplNum ExpirationDate StartDate ARFDate other columns tblSource EmplNum StartDate ARFDate So, I need to select the EmplNum, StartDate, and ARFDate from the source table and update every...
Show full article (0.45Kb)
SQL Query to reterive the modified fields in a history table - New     

Author: Peri
Date: Sep 21, 2007 11:26

Dear All, I would like to write a single sql query to reterive the records where the bank name or notes that has been altered in the following BankDetails Table. Can you please help me out in writing this SQL query. I am... Regards, Peri PS: If my previous input and output was not clear, please look into this excel sheet. begin 666 SQLQueryHistory.xls MT,\...
Show full article (23.63Kb)
Re: query conversion     

Author: UpRider
Date: Aug 31, 2007 06:26

....453518.273390@x40g2000prg.googlegroups.com... hi all & thanks for you your help. I have the following SQL query & I am trying to create a report using the dcount statement listed below the 1st SQL statement, but I am getting errors.please look at the Dcount statement and tell me where I went wrong SELECT Count(*) FROM mydata WHERE (((mydata.CURRENT) Like "...
Show full article (1.96Kb) · Show article thread
Re: use list box for query filter     

Author: Dirk Goldgar
Date: Aug 24, 2007 22:52

...I am creating a form that will ultimately open a table based on a query. One of my filter criteria is a list box that will allow multiple selections. How would the where criteria look in the query i.e. "forms![frm:2000RulesTableFilter]![... other ways, but this is about the most efficient. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
Show full article (1.26Kb) · Show article thread
Re: use list box for query filter     

Author: Douglas J. Steele
Date: Aug 24, 2007 22:49

... the SQL associated with the query. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Cyberwolf" <Cyberwolf@discussions.microsoft.com> wrote in message ... is a list box that will allow multiple selections. How would the where criteria look in the query i.e. "forms![frm:2000RulesTableFilter]![lstRulesTableDetail] or ...
Show full article (1.40Kb) · Show article thread
Re: help in a query plzzz     

Author: Adi
Date: Aug 23, 2007 18:15

... simple question, mit look silly question for some one.. but please look into it n let me know how to write a query for it.. i have 3 cols col1 col2 col3 ----- ----- ------ 123 null 1159 434... the result as follows col ---- null null 234-667 can you please help in getting the result.. thanks Aditya problem solved.. select (...
Show full article (1.04Kb) · Show article thread
help in a query plzzz     

Author: Adi
Date: Aug 23, 2007 17:50

...i have a simple question, mit look silly question for some one.. but please look into it n let me know how to write a query for it.. i have 3 cols col1 col2 col3 ----- ----- ------ 123 null 1159 434 null 1159 555 ... =1159 but i get the result as follows col ---- null null 234-667 can you please help in getting the result.. thanks Aditya
Show full article (0.64Kb)
Re: need a pair of eyes and some help please     

Author: rodchar
Date: Aug 23, 2007 14:58

...rows to be updated, then step by step build on it until I have a query that returns the values that need to be used. Then that gets turned ... <rodchar@discussions.microsoft.com> wrote: Bueler? Please a little help. "rodchar" wrote: hey... hours/pay period Question #1: Please look at the formula below and let me know...
Show full article (8.91Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next