Explore Databases on Experts Exchange

Expert Solutions for Your Tech Problems

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes tha...

Read more
  • 830K Content
  • 45K Contributors

Expert Spotlight
Gary PattersonVP Technology / Senior Consultant

Experienced, hands-on IT expert.  IBM i / iSeries / AS/400, Windows, Linux, security, performance, web, mobile, SQL, RPG, Java, .NET, more.

Solution

InStr works, but InStrRev returns a data mismatch

2020-05-292
Hi,

I'm trying to make a query in MS access. I'm having problems using InStrRev() - getting a …
Solution

Microsft SQL server collation conflict on join

2020-05-293
Although the following procdure compiles ok, the error:

Msg 468, Level 16, State 9, Procedure …
Solution

master/slave operation

2020-05-284
i have 2 ubuntu server with postgres10.
I try to create master slave (second read only) database
Solution

How to list forms and reports dynamically but mask out the selection criteria

2020-05-281
I am attempting to do the following:

I have a list box on a form that uses code to list all forms…
Solution

Email automation in Access 2013

2020-05-283
I am trying to have an email sent automatically when criteria is met on a form.  I have been testing…
Solution

Trying to exclude a specific term of Instr

2020-05-286
Access 365
Instr  trying to negate a value if it is part of the string.

I have an If statement …
Solution

Food Database

byMark01
2020-05-286
I am trying to define the entities for an Access database that will track foods (dishes), such as …
Solution

SSRS SWITCH

bysteven
2020-05-284
We are trying to create a field for the "number shipped" in SSRS, we are unable to change code …
Solution

ODBC driver version 10.00.18362.01 vs 17.5.2.1, should I update

2020-05-282
My control panel says I am using SQL Server ODBC driver version 10.00.18362.01 dated 3/18/2019

I …
Solution

Help to insert the CommFlush function in VBA serial port

My final piece of VBA code in serial port programming is now to insert the CommFlush , this function…
Solution

Help required to pull all the data from the serial port in Ms Access

After serious follow up on my arrangement of VBA as they were heavily criticized by others here, on …
Solution

Adding Query results as new columns to existing table

byFred
2020-05-275
I have a table and trying to add two columns to it to show CallTypeCount and AlarmTime.  The syntax …
Solution

MySQL Query to compare 2 columns in 2 different tables

2020-05-273
I have an inventory of network devices (master). Each week I receive an update in the same schema as…
Solution

install postgresql ?

2020-05-273
how to install postgres 10 on lxd alpine container?
apk add postgresql just add the latest version …
Solution

T-SQL: Join a Query to a CTE

2020-05-275
Hello:

At the end of this posting is T-SQL programming for a CTE.  Prior to this is my "main …
Solution

CronJob Help: Bash Issues

bysj77
2020-05-2627
Hello, Experts,

I reached out today to ask for advice on some bash logic I created. The logic in …
Solution

Setting inheriting permissions

2020-05-262
I have a MS Access database that creates a folder here \\dchs02\eval\ops\employee
Where employee is…
Solution

Variables - Introductory SQL Class

byDan
2020-05-261
Create and populate a Variable to store the number of all employees from Texas



Create and …
Solution

Edit query so that it returns a Distinct row for Grouped data

2020-05-263
The following query outputs multiple rows for a specific set of data.
I need to alter this query …
Solution

Combo Dropdown List

byfrimy
2020-05-261
i want to open the dropdown on a combo as i put the cursor on the Control i.e. StyleNo using …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more