Search results for query: *

hello world i have a SQL table with a memo field containing string lengths from 1 to ~6,000 characters. the client system can only accept strings that are <=75 characters. i have searched some examples of arrays, but most people seem to be splitting by a delimiter or searching for specific...

If I could write this query in Crystal Reports or Access, it would be no problem, but I'm no good at SQL variables. I'm sure something is wrong with my IF/ELSE, and I think I have to declare it as a variable first, but I need help with syntax. SELECT [PartitionID], LEFT([ArchiveID],8)AS Date...

i have this variable in a query: Physician: (Staff.firstName & " " & Staff.lastName & IIf(Nz(Staff.degree),", " & Staff.degree,"")) so if firstName = John and lastName = Doe and degree = MD, the doctor name should be listed as "John Doe, MD". if the degree is null, the doctor name should be...

I'm trying to get a row count using the below formula. My problem is that it only increments at the next record, but the next record isn't the next row. I am using 20 detail sections. In each section I have added the same formula. The data I am pulling is patient lab results. The client...

I have read faq701-4233 I created the new module, but am having more problems. Is it because I'm trying to concatenate a field that is already concatenating two fields from two tables? original code: SELECT Panel.abbreviation, Panel.name, CPT.code & " (x" & Panel_CPT_Map.cptCount & ")" AS...

I need to create a query that compares multiple records in the same table. Below are examples of the data I am looking to compare. In the first list, you can see that one of the records has a different DOB. In the second list, you can see that one of the PATIENT numbers is different. I want...

I am running an Access query and the below works to pull the year out of the Epoch time. However, if I add a year to the criteria section, I get an Overflow error. I don't get this error when the criteria section is blank. What can I do to add criteria? I am using Access 2007 with linked SQL...

I am running a crosstab query and am having a problem getting the totals I am looking for. The crosstab works fine, but I am trying to get monthly totals of a specific lab test, and I need it to count some records in more than one place. In my table, there is a field that lists one of the...

I need to create summaries for text fields that contain data similar to the following: 998563; 458632; 164696; 886543 x2 Each record will have a field with similar data, but each of these numbers that are separated by a semicolon need to be summrized separately. Also, if there is an x2 or...

I am creating an access database that will be used to create unique account numbers. This is all being done with local tables, no linking to tables on a server. This is a single user database. I am not familiar with VBA although I'm guessing I will need to be to do this. In the data entry...

I have seen several posts similar to this, but I haven't found the solution for what I am specifically trying to do. I have a report that lists data from patient visits. The visit name is one of the variables. Sometimes a patient repeats a visit. These are recorded as REPEAT in the...

I am running the following using SQL Query Analyzer. I keep canceling it after 30 minutes. As of right now, there is only one record in my database that it should return, so it shouldn't take that long. Can anyone offer suggestions to speed up this query? SELECT RTRIM(TEST.EXTACCESSION) AS...

i have a report that is pulling data from a table that contains free text information entered by users. in this free text information, i want a pipe character added after every 30 characters. any ideas?