Search results

I need to create a query that combines two columns (lets say Column A and Column B for example) however the problem is that whatever non-null values that are in Column B must replace any value in Column A. If Column B has a value that is null then Column A's value is shown. I have an example...

This statement works on Access, however it turns out that I also need to replicate this line for a query on MS SQL server. DCount isn't a function on SQL server and the Count function only supports one argument. How can I convert this line into MS SQL server? Mfg_Combined" & DCount("*"...

I need to create a query that strings data horizontally that corresponds to the primary key. Example of what I am looking for Fields: Part_No, Mfg_No, Mfg_Name Query Columns: Part_No, Mfg_Info (Mfg_No: Mfg_Name) Also if the part_no (primary key) has multiple values I need the data to...

I have a query to create in access based off a query already created in SQL The SQL query converts a 4 digit number into a date using this code: CAST(CASE WHEN LEFT(OPDT, 2) > 12 OR LEFT(OPDT, 2) = 00 THEN RIGHT(OPDT, 2) ELSE LEFT(OPDT, 2) END + '/' + '01' + '/' + CASE WHEN LEFT(OPDT, 2) > 12...

I'm creating a query for a someone who wants quantities summed by a weekly range and correspond to a week number. This person wants Access to do something that is a simple function on Excel. I have no clue how to do this or if Access is even made to do something like this. This is an example...

Hi this is my first post here. I have this linked table query from a OBDC and I need to be able to filter out specific dates in that query. The dates in the table were in text format and I converted the dates using the CDate function. I wanted to filter the query to a single date and always I...