Search results

I hear there are some books about that kind of thing. :rolleyes:

If I understand your sample data...is your data entered in a couple of different patterns or is it completely random? :confused: Can you first split the data based on pattern, then pass through each pattern to check for the spaces. ie put all the AC1 Text Data patterned records into one...

I think you need a Applicant/Job Opportunity intersection table. Jobs have 1-M applicants Applicants have 1-M job opportunities (applicant status would be here) Jobs have no direct relationship to applicant status

Instead of "transfersheet macro", try "OutputTo". I use this to run queries that output to spreadsheets.

Yup you're right. I like saving things out as a habit, I like to look at the results see if the "seem" right.

Does your wife know about your families tradition? Better yet, does she buy into the idea? I think the finest lingerie is best picked out together. Gift card time! Wrap the gift card up in a nice box with a silky scarf or the like. :) Gail

What do you mean by "pick them out"? Do you want to change the case? Look up StrConv function for help converting text; also try the Asc function.

Try it in two passes. Do your select query first, send that to a temp table. SELECT PatientInfo.Antibioticregime, PatientInfo.AntibioticStartDate, PatientInfo.AntibioticFinishDate INTO TEMP_TABLE FROM PatientInfo WHERE.... Then count the values of the Antibioticregime. All the values will be...

Maybe I misunderstand how a link table functions. I assumed that the data would remain stagnent until I executed the update. But from what you are saying linking is not a point in time picture, it's looking at the table live. I can make a couple simple tests to see if that's true. thanks for...

I have a remote Access table, and a local spreadsheet. End users make updates in the remote Access table and I need to relink to capture those updates. The spreadsheet contains rep/manager information that I manage manually because it's the easiest way to do it. Why would the type of linked...

I create reports from an Access Db that I've created. I have many sources of data that I gather into my DB. I have several linked tables. As part of my monthly update process, I need to update those linked tables to refresh the data that I am reporting on. I am trying to automate as much as I...