Search results for query: *

I have 2 queries. They are exact opposites. But I am losing 4 records. Can anyone help? I am just going to list the 2 queries. First FROM Filter WHERE((((Filter.[TC-530])="TC-530")) Or (((Filter.[TC-150])="TC-150")) Or (((IsNull((Filter.DOD)))=False)) Or (((Filter.DOB)<#1/1/1929#)) Or...

I have a linked table. Several of my fields are not being shown. Any suggestions on how to procede? Reg

Is there a such thing as an If then statement in Access? If so what is the format/ Reg

FROM final WHERE ((((final.[ DOB ])>1929) or ((final.[ DOD ]) Is Not Null) or ((final.[TC-150])<>"TC-150") or ((final.[TC-290])<>"TC-290") or ((final.[TC-291])<>"TC-291") or ((final.[TC-300])<>"TC-300") or ((final.[TC-301])<>"TC-301") or ((final.[TC-420])<>"TC-420" or...

This is the code that I use to pull all the latest years from my query. The problem is that I cannot get my SSN P field to be included. Please help. SELECT [Why not workable].TXPD, [Why not workable].[LFRZ-RFRZ], [Why not workable].[TC-150], [Why not workable].[TC-290], [Why not...

This is the code. I was in the wrong forum earlier. SELECT [Why not workable].[SSN P ], [Why not workable].TXPD, [Why not workable].[LFRZ-RFRZ], [Why not workable].[TC-150], [Why not workable].[TC-290], [Why not workable].[TC-291], [Why not workable].[TC-300], [Why not...

This is the code. SELECT [Why not workable].[SSN P ], [Why not workable].TXPD, [Why not workable].[LFRZ-RFRZ], [Why not workable].[TC-150], [Why not workable].[TC-290], [Why not workable].[TC-291], [Why not workable].[TC-300], [Why not workable].[TC-301], [Why not workable].[TC-420], [Why...

I am writing a query from a query. This is the code SELECT [Why not workable].[SSN P ], [Why not workable].TXPD, [Why not workable].[LFRZ-RFRZ], [Why not workable].[TC-150], [Why not workable].[TC-290], [Why not workable].[TC-291], [Why not workable].[TC-300], [Why not workable].[TC-301]...

I have a table that is linked to a spreadsheet. There are several names and years listed. Each name has multiple year entries. I need to remove 1 year from each name that has multiple years. If there is just one year I need to leave it there. Please help? Reg

I need the code to run an Excel Shell. I have the one for Word ("WScript.shell"). I want to run a spreadsheet with a macro from access. This is the code. Public Sub excel_filter_Click() On Error GoTo Err_excel_filter_Click Set Sh = CreateObject("WScript.Shell") Sh.Run "C:\Documents...

When I combine several queries with the OR command nothing happens. This is a a copy of the code. SELECT final.[SSN P ], final.[SSN S ], final.[SP'S SEC Y97], final.[SP'S SEC Y98], final.[SP'S SEC Y99], final.[SP'S SEC Y00], final.NCCD, final.[ DOB ], final.[ DOD ]...