SELECT TMain.[SWI ID No], TMain.Surname, TMain.[First Name], TMain.[Middle
Name(s)], TMain.Based, TMain.[ID Expiry], TMain.[Initial Agreement Signed],
TMain.[Agrmnt Signed '05], TMain.[Agrmnt Signed '06], TMain.[Agrmnt Signed
'07], TMain.[Agrmnt Signed '08], TMain.[Agrmnt Signed '09], TMain.[Agrmnt
Signed '10], TMain.Area, TMain.[Contract Status], TMain.Location, TMain.Rank,
TMain.Unit, TMain.Status, TMain.[Status Detail], TMain.SNLR, TMain.[Date of
Joining], TMain.[Date of Leaving], TMain.Background, TMain.[Background
Detail], TMain.Image, TMain.[Background Check Type], TMain.[Background Check
Date], TMain.Ship, TMain.[Arrival Date], TMain.[Date of Birth], TMain.[City
of Birth], TMain.[Country of Birth], TMain.Gender, TMain.[Marital Status],
TMain.[Blood Group], TMain.[Eye Colour], TMain.[Hair Colour],
TMain.[Marks/Scars], TMain.[Height (inch)], TMain.[Weight (Lbs)],
TMain.[Uniform Neck Size], TMain.[Uniform Trouser Length], TMain.[Uniform
Waist Size], TMain.[Inside Leg Size (inch)], TMain.[Boot Size (inch)],
TMain.[Chest (inch)], TMain.[Fit for Duty Certificate], TMain.[Address 1],
TMain.[Address 2], TMain.[Address 3], TMain.[Town/City],
TMain.[County/State/Province], TMain.Country, TMain.[Post/Zip Code],
TMain.[Country Dialing Codes], TMain.[Contact No 1], TMain.[Contact No 2],
TMain.[Mobile No], TMain.[E-mail], TMain.[Next of Kin Name],
TMain.Relationship, TMain.[Same As Above], TMain.KAddress1, TMain.KAddress2,
TMain.KAddress3, TMain.[KTown/City], TMain.[KCounty/State/Province],
TMain.KCountry, TMain.[KPost/Zip Code], TMain.[KCountry Dialing Codes],
TMain.[KContact No], TMain.KMobile, TMain.[Passport No], TMain.[Passport
Expiry Date], TMain.[Type of Passport], TMain.[C1/D No], TMain.[C1/D Expiry
Date], TMain.[NI No/SS No], TMain.[DoD ID No], TMain.[DoD ID Expiry Date],
TMain.[DoD Privilege], TMain.[Other Visa No], TMain.[Other Visa Expiry Date],
TMain.[Other Visa Type], TMain.ISPS, TMain.SST, TMain.[Level 1
Anti-Terrorism], TMain.[Non-Lethal Tactics], TMain.[Combat First Aid (UK)],
TMain.[Red Cross First Aid (US)], TMain.VSO, TMain.[CBRD Completion Date],
TMain.[Hazardous Material Training], TMain.[Hazardous Material Expiry Date],
TMain.[Rifle Instructor Training], TMain.[Trafficking In Persons Training
Completion Date], TMain.[Anthrax 1], TMain.[Anthrax 2], TMain.[Anthrax 3],
TMain.[Anthrax 4], TMain.[Anthrax 5], TMain.[Anthrax 6], TMain.HIV,
TMain.Smallpox, TMain.[Every 10 Years -SP], TMain.[Yellow Fever],
TMain.[Every 10 Yrs -YF], TMain.[Tetanus/Diphtheria], TMain.[Every 10 Yrs
-T/D], TMain.[Hepatitis A], TMain.[6 Months After Last 1], TMain.[6 Months
After Last 2], TMain.[Hepatitis B], TMain.[2 Months After Last 1], TMain.[2
Months After Last 2], TMain.[6 Months After Last 3], TMain.Malaria,
TMain.Typhoid, TMain.[Every 2 Yrs (Injectable)], TMain.[Every 5 Yrs (Oral)],
TMain.[Tb Skin Test (PPD)], TMain.[After 1st Year], TMain.[After 2nd Year],
TMain.[After 3rd Year], TMain.[Score 9mm], TMain.[Score 9mm2],
TMain.[Completion Date 9mm], TMain.[Score M14], TMain.[Completion Date M14],
TMain.[Pass AK-47], TMain.[Completion Date AK-47], TMain.[Pass Shotgun],
TMain.[Completion Date Shotgun], TMain.[Expiry Date Small Arms], TMain.[MSC
Approved Weapons], TMain.[Commercial Approved Weapons], TMain.[MSC Wpn Expiry
Date], TMain.[US Firearms Endorsement], TMain.[DCJS ID], TMain.[US
Endorsement Expiry Date], TMain.[MagLight Torches], TMain.[Maglight Holders],
TMain.[Water Bottles], TMain.[WBottle Carriers], TMain.Laptop, TMain.[Laptop
Case], TMain.[Digital Camera], TMain.[Camera Case], TMain.Printer,
TMain.[Printer Cartridges], TMain.[Memory Stick], TMain.[External Hard
Drive], TMain.[Trauma Pack Complete], TMain.Whistles, TMain.Belts,
TMain.[Polo Shirts], TMain.[Equipment Issue Date], TMain.[Winter Jacket],
TMain.[WJ Issue Date], TMain.[Summer Jacket], TMain.[SJ Issue Date],
TMain.Jerseys, TMain.[J Issue Date], TMain.Trousers, TMain.[Tr Issue Date],
TMain.Shirts, TMain.[S Issue Date], TMain.Tie, TMain.[T Issue Date],
TMain.Cap, TMain.[C Issue Date], TMain.[Rain Suit], TMain.[RS Issue Date],
TMain.Epaulettes, TMain.[E Issue Date], TMain.[Pairs of Boots], TMain.[PoB
Issue Date], TMain.[CBRD Mask], TMain.[CBRD Coat], TMain.[CBRD Trousers],
TMain.Rabies, TMain.[Follow up Rabies], TMain.[AK-47 Approval],
TMain.[Current Status]
FROM TMain
WHERE (((TMain.[SWI ID No])=[Enter 4 Digit SWI ID No:])) OR
(((TMain.Surname)=[Enter Employee Surname or Press OK:]));
This is without the extra 3 fields as they don't want to work when inserted.
Kind regards
Rigby
Kernow Girl said:
Hi Rigby - how long is very long?
Yes, it's probably a good idea to post it.
:
Dear Kernow Girl
I have gone through those fields which are used with the prompts, but the
prompt fields (i use 2 in case the person doesnt have the ID number, then
they can use the surname) are unique. At least the ID number is unique and
not used anywhere else. the surname may not be unique, but helps refine the
search and isn't used elsewhere at all. the fields I added are:
Rabies Vaccination (date field);
Rabies Follow Up (date field);
Current Status (combo box).
I am not sure where it is going wrong. I fyou need me to post my entire SQL
statement, I will, but be warned, it is VERY long. (at least, I think so)
Thank you
Kind regards
Rigby
:
Hi Rigby - is is possible that the prompt is the same as one of the new
fields? I did this once when I had a prompt called Date and added a field
called Date.
:
My database is getting big (by my standards). I have a form which uses a
query to edit the records selected using a prompt. It has worked fine for
months now, but I have added some fields to my main table and when I added
them to the query, it won't prompt me any more.
I tried creating the query from scratch and set the criteria the same as
before to prompt me, but it just wont prompt. When i run the query it just
comes up blank. Why is this? How can I fix this?
I need to get this fixed soon, coz the database is in constant use. Please
advise.
Kind regards
Rigby
